Skip to Content
0
Former Member
Mar 24, 2009 at 09:28 AM

LEFT OUTER JOIN and INNER JOIN in same select

3607 Views

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