"Actually, no. I specifically demonstrated using column names instead of * to demonstrate that the key fields don't have to be the same. Only the fields in the queries...

Goal: "All records that exist in one table but not the other"

I am assuming that the two tables have a common key, for my example I will use ID

Select a.Field1, a.Field2...,...