Ordering 2 tables query

[5ilver5aracen]

Hi, I have 2 tables. TableA contains course details and TableB contains the dates that these courses are on. There can be many dates for each course. I have tried quite a few sql statements to try and produce a list of courses that are in date order. The courses need to be ordered by their earliest date and the courses should only appear once in the list. It sounds simple but I cant seem to work it out. It would work if a GROUP BY could be used with a ORDER BY! Many thanks in advance. SilverSaracen

 

[JamesLean]

Do you mean this?

SELECT a.coursename, MIN(b.coursedate)
FROM tablea a JOIN tableb b ON a.courseid = b.courseid
GROUP BY a.coursename
ORDER BY MIN(b.coursedate)

--James

 

[5ilver5aracen]

Thanks James. That worked a treat.