I am using an old database call Centura Gupta that doesn't have the join
clauses (left join, right join, inner join, outer join). So I need to use where
to replace the outer join
that I need:
SELECT *
FROM table1
OUTER JOIN table2
ON table1.id_person table2.id_person;
I think that where
can only replaces inner join
:
SELECT *
FROM table1
WHERE table1.id_person = table2.id_person;
I used this kind of implementation when I didn't know JOINs. May not be exactly right but something which can get you close: