[RESOLVED] MySQL Query Help

[danbopes]

Hi, just want to thank everyone ahead of time for their help.

I have a database, that has a list of teams, and it has two fields called owner and captain. Those are id's that match member_id in another forum. What I want to do is get the member_id from that table, but if its not there I want it to return with null if the member_id doesn't exist.

I know I can do a simple left join to grab it if it had one id, but I don't know how to do this with two ids.

[tomhath]

Untested:

select t.*,  m1.member_id as owner_member, m2.member_id as captain_member 
from Teams t
left join Members m1 on m1.member_id = t.owner 
left join Members m2 on m2.member_id = t.captain

[danbopes]

Thank you, I knew it was something along the lines of that. Thank you for your help, first time I came to this forum and you were very helpful. Thanks again.