In the attached spreadsheet, the first tab lists a diagram of three tables. Tables A (Green) and B (Blue). Table C was created by an inner join on Tables A and B, on the fields Car, NBR1, and NBR2.
Now, based on Table C that was created from A and B, I am creating a three table query with C, D, and, E, with the intended output to deliver Table Z that has the rows highlighted in pink (where the Code, ID in Tables D and E are not the same).
Tables C, D, and E will be joined on Car, NBR1, and NBR2 as well. Due to the nature of the source data, the processing had to happen in this method, and cannot be changed.