Problem in simple SQL request - TechRepublic
General discussion
September 19, 2001 at 02:57 AM
zeus who frags

Problem in simple SQL request

by zeus who frags . Updated 24 years, 8 months ago

Hi everybody! I have a little problem here.

I work under Microsoft Access 97.
I have 2 tables : A and B. The key of A are the same fields as the key of B (so, records are “equivalents”). Many records in A have no correspondant in B but all records in B have a correspondant in A.
I want to SELECT all records in A that have NO correspondant in B (of course, the classical “SELECT A.* FROM A,B WHERE A.key=B.key” is the exact contrary that I want!).
Can someone help, please ?
Thanks!

This discussion is locked

All Comments