5ilver5aracen
Programmer
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