Got a table1:
Got a table2:
ID is autonumber.
Trying to insert from Table1 field1, ... , field7 if field1, ... , field7 do not exist in table2.
my query:
INSERT INTO table2 ( field1,field2, field3, field4, field5, field6, field7 )
SELECT a.field1, a.field2, a.field3, a.field4, a.field5...