XOR relationship between three tables
219699Mar 30 2007 — edited Mar 30 2007Hi all,
I have a SQL problem and I can't resolve it:
I have 3 tables: parent table: tableA, and two child tables : tableB and tableC.
but tableC is also a child of tableB.
so I have two cases of returning data:
1- select data from tableA and tableC (inner join)
or
2- select data from tableA and tableB and tableC (inner join A and B + inner join B and C).
How can I achieve this?
thx