Unmatched Query -- Fields do not appear

P

pdlginternet

I'm trying to construct an unmatched query and for some reason,
suddenly when I get to the part of the wizard where it allows me to
select the fields on which to do the compare, no fields appear.
Perplexing. Any ideas?
 
P

pietlinden

I'm trying to construct an unmatched query and for some reason,
suddenly when I get to the part of the wizard where it allows me to
select the fields on which to do the compare, no fields appear.
Perplexing. Any ideas?
Click to expand...

Your wizard is screwed up.

Do it by hand... it's just an outer join.
Say you have two tables, A and B.
To see all the records from A that are not in B...

SELECT *
FROM A LEFT JOIN B ON A.PrimaryKey=B.ForeignKey
WHERE B.ForeignKey IS NULL;

Wizards are good, but sometimes you gotta get dirty...
 
Top