Re: SQL join between 3 tables

[Peter Brawley]

Build such queries bottom to top, first the joins, then the select exprs ...

select p.name as phrase, t.name as language, t.translation
from phrase p
left join translation t on p.id.=fk_phrase
join language l on t.fk_language=l.id;