Help with JOIN active record class

[eluser]WanWizard[/eluser]
Read up on the different types of JOINS. Wikipedia has a good article on them.

In this case, you need a left join:

Code:

$this->db->join('products_images', 'products_images.id_product = products.product_id', 'LEFT');

Note that all fields missing in the result (because there was no matching record to join) will have the value NULL. You'll have to test for this in your application.