Appending Query Problem

[tessie]

I have imported a table to an existing database. I want to merge two tables(A and B) together. I did an append query. What it is doing when I run this is that it is selecting records from both tables that have a matching value in the fields that are joined - I take this is called INNER JOIN. My question is how can I include the records that are in table A that is not in table B???

Thanks in advance for the help!

 

[joeselch]

run the "Find Unmatched Query Wizard"

 

[tessie]

Hello,

I have run the "Find Unmatched Query Wizard" and it found the records that are not on table A. But how do I add these unmatched record to Table A so that I do not have to use Table B. There are around 200 unmatched record that I need to merge to Table A. Thanks again for your help.

 

[mdemarte]

Now, create an append query using the unmatched query as the source.