Join, if?

[eluser]Phil Sturgeon[/eluser]
Would a right join not do the trick?

Code:

$this->db->join('translations', 'trans_ref_id = news_id', 'right');

That means if you have a news_id, but there is no matching trans_ref_id, it will load NULL for all the fields in translations.