SQL query that will take from 1 table and place into another

[adamr1001]

Hi,

I need an SQL query that will take data from one table, and place it into an existing table, without overwriting the records that already exist, defined by a unique field.

this is what i've got so far (feel free to correct if its not right (i am a beginner):

SELECT <Data/column i want> INTO <table to be modified
FROM <source table> WHERE ? ;

what is the most efficient code to place in the Where section. Thanks in advance to anyone who can bail me out.

Adam.

 

[sko]

First of all, an append query (which is what you are trying to do with &quot;insert into&quot adds records to the table. Nothing is overwritten.

Give us more information about the tables and fields. Is your primary key autonumbered?