Q EVENT * * Or the one provided by Stephen early today:
select client_schedules.schedule_name,client_schedules.action,client_schedules. star ttime,associations.node_name - from client_schedules,associations where client_schedules.schedule_name=associations.schedule_name Regards, Rama -----Original Message----- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of LeBlanc, Patricia Sent: Thursday, September 28, 2006 9:43 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] Select statements But it wont give you the schedule time. -----Original Message----- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Lee, Gary D. Sent: Thursday, September 28, 2006 9:41 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: Select statements Why not just do a Q assoc * * That will give you every schedule and association. Gary Lee Senior System Programmer Ball State University -----Original Message----- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of LeBlanc, Patricia Sent: Thursday, September 28, 2006 9:25 AM To: ADSM-L@VM.MARIST.EDU Subject: Select statements I need a select that will give me all of my client schedules and tell me who is associated with them and what time they run. Client_schedules and associations are the tables I need. Just can't get my select to work. Any ideas? Not sure of the syntax on joining them. thanks -------------------------------------------------------- If you are not an intended recipient of this e-mail, please notify the sender, delete it and do not read, act upon, print, disclose, copy, retain or redistribute it. Click here for important additional terms relating to this e-mail. http://www.ml.com/email_terms/ --------------------------------------------------------
