Join query for 3 tables

[Radek Zajkowski]

I have three tables:

users <- holds user details
courses <- holds course information
registrations <- holds id values which specify which course did a user 
register to eg. user #1 registered for course #4

I tried but to no avail to create a query where all users are selected, 
all their registrations and the course data except so far I can only do 
it to indicate those who registered,

I would like to do it the way LEFT JOIN does so I end up with all users, 
their registrations and names of the courses they registered in one query.

eg. Robert Smith | French
        Mark Mark |
        Danny Dan | French
no registrations would mean empty value.

Thanks is advance

R>

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]