How to form a join query to the database to display unrelated data as well?

Question

PHP

Such a query outputs a string and blocks within it. If there are no blocks, the line is not displayed. How can I make an empty line also displayed?

$this->db->from('blocs');
$this->db->join('rows', 'rows.id = blocs.id');

Answer 1

right outer join