join 2 tables with 2 foreign keys

[jonno946]

Hi there,

I have one table with 2 foreign keys.

As an example, i have posted_by_user_id and edited_by_user_id.

How can i do a left join with 2 foreign keys?

Cheers,

Jonno.

[Lars_Berg]

select t1.name as posted_by, t2.name as edited_by, ...
 from postTable p left join nameTable t1 on p.posted_by_user_id = t1.id
 left join nameTable t2 on p.edited_by_user_id = t2.id