Try something like this...

select cs.domain_name,cs.schedule_name, cs.starttime,
cs.dayofweek,a.node_name -
  from associations a, client_schedules cs -
 where a.domain_name='WINDOWS' -
   and a.domain_name=cs.domain_name -
   and a.schedule_name=cs.schedule_name -
 order by a.node_name, cs.dayofweek, cs.starttime

You can fiddle with the 'order by' clause to sort it however you wish...
-Ken

-----Original Message-----
From: Joni Moyer [mailto:joni.moyer AT HIGHMARK DOT COM]
Sent: Tuesday, May 03, 2005 7:45 AM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: select statement possible?


Hello All!

I would like to create a report of all nodes and their respective schedules
within the windows domain.  I know that this will require a join between
the associations table and the client_schedules table, but I am unsure of
how to accomplish this task.

I know that a statement to get the client schedules info. would be select
domain_name,schedule_name,starttime,dayofweek from client_schedules where
domain_name='WINDOWS'
and the select statement for the associations info. would be select
domain_name,schedule_name,node_name from associations where
domain_name='WINDOWS'

Any help is appreciated.  Thanks!

********************************
Joni Moyer
Highmark
Storage Systems
Work:(717)302-6603
Fax:(717)302-5974
joni.moyer AT highmark DOT com
********************************