Query to update a table

[ChrisNWV]

I am comparing two tables (ComparisonTable2 & NewChanges). The primary


key is AppReg. I am able to compare them and make changes by the
comparison, however, I want to update ComparisonTable2 with the new
information from the NewChanges table. A change will only occur if during
the comparison an AppReg is in the Newchanges table but not in the
ComparisonTable2. I know I am close to the answer. Everytime I run
the below code it is asking me for a parameter. When I remove the
last line of code it simply copies all of the data from NewChanges
into ComparisonTable2. Any assistance would be greatly appreciated.

INSERT INTO ComparisonTable2 ( AppReg, Manufacturer )
SELECT NewChanges.[AppReg], NewChanges.[Manufacturer]
FROM NewChanges
WHERE NewChanges.AppReg <> ComparisonTable2.AppReg;

[June7]

Try:

WHERE NewChanges.AppReg Not In (SELECT AppReg FROM ComparisonTable2);

[Dal Jeanis]

INSERT INTO ComparisonTable2 ( AppReg, Manufacturer )
SELECT NewChanges.AppReg, NewChanges.Manufacturer
FROM NewChanges 
WHERE NewChanges.AppReg NOT IN 
(SELECT ComparisonTable2.AppReg FROM ComparisonTable2);

Hah! June beat me!

[ChrisNWV]

THANK YOU!!!
It worked fine!!!