Re: Select statements

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:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
LeBlanc, Patricia
Sent: Thursday, September 28, 2006 9:43 AM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: [ADSM-L] Select statements


But it wont give you the schedule time. 

-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Lee, Gary D.
Sent: Thursday, September 28, 2006 9:41 AM
To: ADSM-L AT VM.MARIST DOT 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:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
LeBlanc, Patricia
Sent: Thursday, September 28, 2006 9:25 AM
To: ADSM-L AT VM.MARIST DOT 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/
--------------------------------------------------------