I have 9 tables, namely: A, A1, A2, B, B1, B2, C, C1, C2. I need to join C, C1 and C2 with Left Outer Join and with the result, I need to join them to B, B1 and B2 (which is also joined by Left Outer Join) which will then
be join to A, A1, A2 (Left Outer Joins as well) with Inner Joins. The statement should resembles the following:
A Inner Join B Inner Join (C Left Outer Join C1 Left Outer Join C2) Where A.name = 'Simon' And B.food = 'pizza'
Basically I need to match the joint results of
A, A1, A2;
B, B1, B1;
C, C1, C2;
and take the the items that are common among the 3 groups.
How do I achive this in a single sql statement?
Thanks in advance.
View Complete Post