Works like a dream!
thanks so much.
thomas
On 26 Apr 2002, Diana Soares wrote:
> Hi, try this:
>
> SELECT courses.coursetitle,reservationid
> FROM courses,applicant LEFT JOIN reservation
> ON (reservation.applicantid = applicant.applicantid AND
> reservation.coursesid = courses.coursesid)
>
Hi, try this:
SELECT courses.coursetitle,reservationid
FROM courses,applicant LEFT JOIN reservation
ON (reservation.applicantid = applicant.applicantid AND
reservation.coursesid = courses.coursesid)
WHERE applicant.applicantid = 1
This gives you all courses an reservationid>0 if applicant has
