update a table with new info from another table

  • Thread starter Thread starter Marie A Roy
  • Start date Start date
M

Marie A Roy

I want to merge 2 tables: the first is the original in
which some records already have data in it but some
are 'empyy' (ie There is an identifications number for
each records but the other columns are empty). The 2nd is
the same table but with the additional information for the
empty records of the original table. Anybody would have a
suggestion about updating the original table with the
values coming from the 2nd table?
 
Hi,
SQL = "UPDATE Table1, Table2 SET Table1.Field1 =
Table2.Field1, Table1.Field2 = Table2.Field2,...
WHERE Table1.Key = Table2.Key"

OR

SQL = "UPDATE TABLE1 INNER JOIN TABLE2 ON TABLE1.Key =
TABLE2.Key SET TABLE1.FIELD1 = TABLE2.FILED1,..."

This works in Access.

Khalid
 
Back
Top