SQL statements for Unmatched Query Wizard

[Padma]

Hi, I am unable to use the 'Find UNmatched Query Wizard'
because the option is not available.
Can i have the query logic.
I am trying to find records in Table A that are not in (no
matching record in )Table B.

 

[Michel Walsh]

Hi,


SELECT a.*
FROM a LEFT JOIN b
ON (a.f1=b.f1 AND a.f2=b.f2)

WHERE b.primarykey Is Null



I assume there is a record match if ( a.f1=b.f1 AND a.f2=b.f2 ) . Modify
that criteria to suit your case.

If b has no primary key, try to use one of the field from b implied in the
record match criteria.


Hoping it may help,
Vanderghast, Access MVP