Add Update Records

[LJG]

I Have 2 tables

Table A
Table B

Ana created an update query

Table A has new data that is required to update items in table B.

Table A has 20 records, Table B has 19

When I run the update, Table B still has 19 records and the new record added
is ignored.

Anyone help me with this add/update

TIA

Les

 

[Ofer]

INSERT INTO Table_B
SELECT Table_A.*
FROM Table_A LEFT JOIN Table_B ON Table_A.Join_Field=
Table_B.Join_Field
WHERE Table_B.Join_Field Is Null

that will return and insert the records in A that are not
in B.
I hope the table A and B are the same build.