I am using Ingres 11.0 DB not sure if it will have same behavior on other DB engines ,but here is it SELECT * FROM table1 t1 LEFT JOIN table2 t2 ON t1.id = t2.fk_id WHERE t1.code = ‘CODE1’ …
I am using Ingres 11.0 DB not sure if it will have same behavior on other DB engines ,but here is it SELECT * FROM table1 t1 LEFT JOIN table2 t2 ON t1.id = t2.fk_id WHERE t1.code = ‘CODE1’ …