Insert with Where Statement Not Working

[EzGoingKev]

I am using the following statement:

INSERT INTO table1 SELECT * FROM query2 WHERE 'table1.ID'<>'query2.ID'

There is already data in table1. I want to it to insert data to the table only where there already is not data listed using that ID

The macro runs but it just inserts everything from query2 into table1. It ignores the WHERE 'table1.ID'<>'query2.ID'.

What am I doing wrong?

 

[Ranman256]

build sql using the query design. It wont get it wrong. In fact, just use queries. There's not a big need to write sql.
but I think you used quotes.
fields don't need quotes, only strings you create as litterals.

iNSERT INTO table1 SELECT * FROM query2 WHERE table1.ID<>query2.ID

 

[theDBguy]

Hi. You could try something like:

INSERT INTO table1 SELECT * FROM query2 WHERE ID Not In(SELECT ID FROM table1)

 

[EzGoingKev]

build sql using the query design. It wont get it wrong. In fact, just use queries. There's not a big need to write sql.
but I think you used quotes.
fields don't need quotes, only strings you create as litterals.

iNSERT INTO table1 SELECT * FROM query2 WHERE table1.ID<>query2.ID

If I try to run it without the quotes I get the following error:

Syntax error in query expression 'table1.id<>query2.id'

Initially I tried brackets but they gave me an error also.

 

[EzGoingKev]

Hi. You could try something like:

INSERT INTO table1 SELECT * FROM query2 WHERE ID Not In(SELECT ID FROM table1)

That worked. Thanks.

 

[theDBguy]

That worked. Thanks.

Congratulations! Glad to hear you got it to work. Good luck with your project.