join query help

[TheEvilMonkeyMan]

Hey maybe somebody can help me with this query... I have two tables - jobs and users. Each job row has 'master_id' and 'slave_id' which relate to a user_id in the users table. I'd like to get a job row containing master_id and slave_id resolved to a username by id preferably in one query. I had it working somewhat at one point except that it wouldn't return rows where slave_id was null.

 

Thanks

[Mchl]

SELECT j.*, m.username, s.username
FROM
  jobs AS j
LEFT JOIN
  users AS m
ON
  (j.master_id = m.user_id)
LEFT JOIN
  users AS s
ON
  (j.slave_id = s.user_id)