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
