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]