That query isn't really doing what you originally asked. It won't return
doctors with no trials. You'll need an outer join for that.
----- Original Message -----
From: "Al Musella, DPM"
> Worked perfectly! Thanks!
>
> Al
>
> >
> >SELECT c.name, MIN(dateupdated) as oldest_trial
> >FROM contacts c, trials t, contactdetails cd
> >WHERE c.contactID = cd.contactID
> >AND t.trialID = cd.trialID
> >GROUP BY c.name
> >
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
