I have created the database attached. I need a query that somehow matches a row from the original table with a row from the new table. The query I want should get from both tables those that
1) Have the exact same Code1 and Code2,
2) Have a different CName,
3) Have the same Test.
It works fine except for one thing: The query is creating combinations. I would like the query to look like the "WantedResult" table
Could you please help me?