Got a table1:
Trying to insert from Table1 field1, ... , field7 if field1, ... , field7 do not exist in table2.
my query:
my query is slow.
1) how to make it faster without using the ID?.
2) how to limit the insert to the top 10 IDs in Table1?.
Got a table2:ID, field1, field2, field3, field4, field5, field6, field7
ID is autonumber.ID, field1, field2, field3, field4, field5, field6, field7
Trying to insert from Table1 field1, ... , field7 if field1, ... , field7 do not exist in table2.
my query:
Code:
INSERT INTO table2 ( field1,field2, field3, field4, field5, field6, field7 )
SELECT a.field1, a.field2, a.field3, a.field4, a.field5, a.field6, a.field7
FROM Table1 AS a
WHERE (a.field1 and a.field2 and a.field3 and a.field4 and a.field5) not IN (SELECT
b.field1 and b.field2 and b.field3 and b.field4 and b.field5 FROM table2 b where a.field1=b.field1
and a.field2=b.field2 and a.field3=b.field3 and a.field4=b.field4 and a.field5=b.field5);
1) how to make it faster without using the ID?.
2) how to limit the insert to the top 10 IDs in Table1?.