Query - Single records

Hi everyone

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?

Thanks!