Get Parts that are not in both tables 1

[NBVC]

Hi,

I have 2 tables.. a PART table and an INVENTORY_TRANSACTION table.

How would I query all the Parts in the PART table that do no appear in the INVENTORY_TRANSACTION table.... (Both contain PART_ID field).

Thanks.

 

[lbass]

Use a left join FROM the Part table TO the inventory transaction table, and then use a record selection formula like this:

isnull({inventory_transaction.part_id})

-LB

 

[NBVC]

Thank you very much LB... I think it worked!