How can you join tables while keeping all rows from the main table?
Specifically using CodeIgniter's database library.
For example, the below code only returns joined rows from table1
and table2
where the condition applies for both tables.
How do you return all rows from table1
and only join rows from table2
where the condition applies?
$this->db->join('table2', 'table2.col = table1.col');
$query = $this->db->get('table1');