D deb Jan 22, 2004 #1 How do I write a query where I want the return to show records that appear in table A and Table B but not in Table C?
How do I write a query where I want the return to show records that appear in table A and Table B but not in Table C?
K Ken Snell Jan 22, 2004 #2 Something like this to get you started: SELECT A.* FROM ([Table B] AS B INNER JOIN [Table A] AS A ON B.LinkingFieldName = A.LinkingFieldName) LEFT JOIN [Table C] AS C ON A.LinkingFieldName = C.LinkingFieldName WHERE C.SomeOtherFieldName Is Null;
Something like this to get you started: SELECT A.* FROM ([Table B] AS B INNER JOIN [Table A] AS A ON B.LinkingFieldName = A.LinkingFieldName) LEFT JOIN [Table C] AS C ON A.LinkingFieldName = C.LinkingFieldName WHERE C.SomeOtherFieldName Is Null;
