EzGoingKev
Registered User.
- Local time
- Today, 08:02
- Joined
- Nov 8, 2019
- Messages
- 178
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?
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?
Last edited: