Prev: howto copy only newer OrderID data(and the other fields) from one
Next: Eliminating duplicates in Access 2007
From: Marshall Barton on 1 Mar 2010 12:27
Bartus wrote:

>howto copy only newer OrderID data(and the other fields) from one
>table to another table
>
>So the new table is updated only with the new OrderID and the
>OrderID's already copyied earlier are not also added everytime.
>
>i use the append query i think and need certainly some criteria
>(filters)?


INSERT INTO table2 (OrderID, f1, f2, ...)
SELECT OrderID, f1, f2, ...
FROM table1 INNER JOIN table2
ON table1.key = table2.key
WHERE tabl2.key Is Null

--
Marsh
MVP [MS Access]
 | 
Pages: 1
Prev: howto copy only newer OrderID data(and the other fields) from one
Next: Eliminating duplicates in Access 2007