Update Query basic

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have Table1 with field Track, I want to update with info from field Track
in Table2
add both tables to design view field track but don't know what to put in
update too.
Am missing something here - hope you can help. Want to eventually use this
to update adress fields from one table to another with EmpID connecting each.
 
UPDATE table2 INNER JOIN table1 ON table2.ItemID= table1.itemID
SET table2.UnitPrice = table1.UnitPrice


would update the unit price of table2 with the unit price coming from
table1, for the same itemID (ie, the APPLE unit price won't be updated by
the ORANGE unit price ! )


Hoping it may help,
Vanderghast, Access MVP
 
Back
Top