I'm trying to do an outer join in MySQL to identify records not common to 3 tables. Here's my current effort http://sqlfiddle.com/#!2/02b92/30
I'm trying to retrieve the records not common to all three tables: 2,C,c (tbl2) 6,E,c (tbl3). Instead, I'm getting back the one common record: 1,A,c.
SELECT * FROM tbl1 A LEFT OUTER JOIN tbl2 B ON( A.a = B.a AND A.b = B.b AND A.c = B.c ) RIGHT OUTER JOIN tbl3 C ON( B.a = C.a AND B.b = C.b AND B.c = C.c ) WHERE A.a is not null;