Append query problem

[mrrayj60]

I have a table of vendors but some are missing, I need to go thru each table and find the missing records. Append query seems the way to go but I cannot get it to identify a record from table bcp108 that is not in table Vendors. It wants to add the records I already have there.
Hope this is enough info, when I dont use joins it gives me like 2,000 appends where the actually number should be around 10-15...
Thanks, Ray

INSERT INTO vendors ( NUM, NAME, COMENT01, COMENT02, CONTACT, DFLTGL, DISC, DISCDAYS, EFTYN, EMAIL, FAX, FEDID, FNAME, FORM1099, INSCAR01, INSCAR02, INSDATE01, INSDATE02, INSPOL02, INSPOL01, NAME, PHONE, SPECIAL, STATUS, VADDR101, VADDR201, VCITY01, VSTATE01, VZIP01, MODIFYTIME )
SELECT bcpap108.NUM, vendors.NAME, bcpap108.COMENT01, bcpap108.COMENT02, bcpap108.CONTACT, bcpap108.DFLTGL, bcpap108.DISC, bcpap108.DISCDAYS, bcpap108.EFTYN, bcpap108.EMAIL, bcpap108.FAX, bcpap108.FEDID, bcpap108.FNAME, bcpap108.FORM1099, bcpap108.INSCAR01, bcpap108.INSCAR02, bcpap108.INSDATE01, bcpap108.INSDATE02, bcpap108.INSPOL02, bcpap108.INSPOL01, bcpap108.NAME, bcpap108.PHONE, bcpap108.SPECIAL, bcpap108.STATUS, bcpap108.VADDR101, bcpap108.VADDR201, bcpap108.VCITY01, bcpap108.VSTATE01, bcpap108.VZIP01, bcpap108.MODIFYTIME
FROM vendors RIGHT JOIN bcpap108 ON vendors.NUM = bcpap108.NUM
WHERE ((([bcpap108]![NUM])=[vendors]![NUM]))
ORDER BY bcpap108.NUM, vendors.NUM;

 

[ajetrumpet]

you need a subquery, not an equality. THIS:

WHERE table1.field NOT IN (

SELECT [field] FROM table2)

not this:

WHERE table1.field = table2.field

 

[mrrayj60]

That worked perfect, Thanks for your help.
Ray