Using INSERT INTO to append rows from one table to another

[pcrist]

I want to append rows from one table to another, however, I want to be able to check a specific row to make sure there aren't duplicates. FirstName LastName VINPeter Smith WDD1Jon Doe WDD2 FirstName LastName VINNAlex Taco WDD3Peter Smith WDD1 For exampled, I'd want to append those two tables together so that it would consist of only three rows (i.e. by not appending the duplicated Peter Smith entry. I'm using this statement as of now: INSERT INTO TableOneSELECT * FROM TableTwo WHERE VIN <> VINN ... However, this asks me to enter a parameter value for VIN. Thanks for any adviec you can give, I'm using SQL within Access.

Edited December 18, 2012 by pcrist

[justsomeguy]

INSERT INTO TableOne SELECT * FROM TableTwo WHERE VIN NOT IN (SELECT VINN FROM TableOne)