Select X where not in. . .

[liddlem]

Hi readers
I have 4 tables as follows.

TblBCode - Barcode, BCType
TblUsers - Users, UserGrp
TblHardware - SerialNo, HWType, and some other fields.
TblHWTypes - HWType,Description

I want to ceate a query that selects all records in TblBCode where BCType is not in TblHWTypes.HWType

I think it can be done in SQL, but can it be done in Access?

 

[MarkK]

How would you do it in SQL?

In Access try ...

SELECT * FROM Table WHERE ThisField Not In 
( SELECT ThatField FROM OtherTable )

...but the JetSQL In operator is the key.
Mark

 

[liddlem]

I knew there had to be a way - Thanks