Re: SQL query problem

["Mattastic" <webforumsuser@xxxxxxxxxxxxxx>]

I have another problem with my query.

 Currently I'm using this sql to extract courses with multiple sessions:

 SELECT * FROM ptcourses08 c , coursesession cs 
 WHERE 0=0 
 AND c.courseid = cs.sessioncourse
 ORDER BY c.courseTitle

 This works fine for courses that have sessions, but it doesnt pick up full 
time courses that dont have sessions, courses that just appear in the 
ptcourses08 table only.

 Can anyone tell me how I can get all the courses?

 Thanks in advance