join problem

[eluser]Josepzin[/eluser]
Thnaks aquary!!!!

It works, your two options are good!

#1 JOIN + WHERE

Code:

$this->db->where('catalogs_arranges.key', 'nexts');
$this->db->join('catalogs_arranges', 'catalogs_arranges.table_id=catalogs.id', 'LEFT');

#2 ONLY JOIN

Code:

$this->db->join('catalogs_arranges', 'catalogs_arranges.table_id=catalogs.id AND catalogs_arranges.key="nexts"', 'LEFT');