Upate statement?

  • Thread starter Thread starter js
  • Start date Start date
J

js

Hi,

Can I put two table in one update statement like this:
UPDATE tb1, tb2 SET _tb1.ID= tb2 .ID

What it will do? Please advice.
 
What you will get is an offer to update rows in tb1 that don't exist. If
there are 5 rows in tb1 and 7 in tb2 then Access will tell you that "You are
about to update 35 rows" and ask if you want to continue. You will need to
link the two tables on a common field so that Access will know which tb2.ID
goes with which row in tb1.
 
Back
Top