extend 2 table join to include 3rd table

SeenGee

i am currently doing a 2 table left join to retrieve the names of dj's (stored in a table called users) and associate them with specific time slots that have the dj_id stored as content.
The join is on dj_id from slots (the schedule table) and user_id from users.

this is the sql:

$sql = "SELECT users.user_id, users.username, slots.*
		FROM `slots` 
		LEFT JOIN `users` ON users.user_id = slots.dj_id
		WHERE `dayofweek` = '$dd' AND `month` = '$mm' AND `year` = '$yy' LIMIT 0, 30";

This works fine but what would i do if i wanted to also draw info from a third table called djextras that has info such as dj_img, dj_biog and references the users table with user_id.?

Thanks.

Sxooter

$sql = "
SELECT 
  users.user_id, 
  users.username, 
  slots.*
FROM slots s
LEFT JOIN  users u
ON (u.user_id = s.dj_id)
LEFT JOIN djextras dj
ON (dj.djekey = u.user_id)
WHERE dayofweek = '$dd' 
AND month = '$mm' 
AND year = '$yy' 
LIMIT 0, 30";

replace djekey with the right field from djextras

SeenGee

nice one, didnt realise it would just mean adding another join. thanks.