3 tables:
Contacts: name and contactID (one entry for each doctor)
Trials: Has List of clinical trials. TrialID, DateUpdated (each trial can
have multiple doctors, each doctor can have multiple trials)
ContactDetails: ContactID, Trial ID (for many to many relation, doctors
can have none, one or many entries)
I want to list the names of each doctor (even if they have no trials), and
the date of the single OLDEST trial (dateupdated).
Can anyone help? thanks!
I am using sql 7.0
Al
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
