
March 16th, 2000, 12:49 PM
|
|
Apprentice Deity
|
|
Join Date: Jul 1999
Location: Niagara Falls (On the wrong side of the gorge)
Posts: 3,237

Time spent in forums: 4 m 8 sec
Reputation Power: 17
|
|
|
Well, you haven't stated what table qualification and exambody are on as you will need to specify if either field name appears in more than one table. With that in mind, this should work:
select distinct qualification,distinct exambody from qualifictions q,exambodies eb, examdates ed where q.QualificationID = ed.qualificationID and eb.ExambodyID=ed.exambodyID order by qualification,exambody
|