join problem

[eluser]Josepzin[/eluser]
Thanks Matalina, i think you do not understand my question

I replace the JOIN by sub SELECT:

Code:

$this->db->select('(SELECT arrange FROM catalogs_arranges WHERE catalogs_arranges.key="nexts" AND catalogs_arranges.catalog_id=catalogs.id) AS arrange');

It works, but i think JOIN may be is better.