Hi,
I have 3 tables with following key field values (column is kalled id):
ztab1: one, two, three, four
ztab2: one, two, three
ztab3::one, two
I want to INNER JOIN table 2 and 3 and I want to LEFT OUTER JOIN table 1 and 2. So the result set I am expecting is values one, two, three, four.
This is my select that is not working but only returning one,two, three (four is missing).
SELECT ztab1~id
FROM ztab1 LEFT OUTER JOIN ztab2
ON ztab1~id = ztab2~id INNER JOIN ztab3
ON ztab2~id = ztab3~id
Why is this returning only one, two, three and not the four as well and how can I rewrite this select to that it works?
thanks