criterium coming from another query

[khhess]

Hi,
I have two tables, a and b both tables are having a primary key.



How do I add data records from tableA into tableB if the primary doesnt exist.
I used the query builder to list all records in tableA without an existing record in tableB.

But I found no way to the data from query1 to create a query to copy these records in tableB.

Any idea?

[alansidman]

If you want to have all the data in B included in A, then if the tables are in similar layout, you could do a UNION query.

Here is information on UNION queries.

http://www.techonthenet.com/sql/union.php

Alan

[khhess]

Thanks,
but table B is on a web server with 6000+ records and table A is my computer.
What I did, I checked by using Dlookup if record exsit, if not I insert the missing record.
Now I also want to update existing records, but if I update everytime all records, this will take for ever.
So I thinking to add a timestamp to identify if a record was changed or you know a better solution.

Thanks