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:[EMAIL PROTECTED] Sent: Tuesday, May 03, 2005 7:45 AM To: ADSM-L@VM.MARIST.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 [EMAIL PROTECTED] ********************************
