Hi,
I have tried to explain the query by using a Venn diagram - see the attached image!
The query is made of three parts like this:
Part 1
Retrieve records where fields C, D and E exist and match in Table 1 and Table 2
Part 2
Retrieve records where fields C, D and E exist in Table 1, but not...