pcrist Posted December 18, 2012 Share Posted December 18, 2012 (edited) 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 Link to comment Share on other sites More sharing options...
justsomeguy Posted December 18, 2012 Share Posted December 18, 2012 INSERT INTO TableOne SELECT * FROM TableTwo WHERE VIN NOT IN (SELECT VINN FROM TableOne) Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now