Thanks For Left Join but...

[mud2]

It wworks, but what wierd sort of language is it? To my C++ type mind it sure doesn't make sense!

[matthewspatrick]

Example, please?

[geekgirlau]

Mud, this is the SQL language in Access. The LEFT JOIN shows the related field, and indicates that you are going to get all the records from Table1, regardless of whether there is a matching record in Table2. Because you have specified that Field1 in Table2 is null, you will get all records in Table1 that specifically DO NOT have a record with a matching Field1 in Table2.

And obviously the INSERT INTO is going to take all the records found and append them into Table2.