Update the values in a table from another table

  • Thread starter Thread starter Billiam
  • Start date Start date
B

Billiam

What type of query would i use in the following scenario...
I have a table called UserPW, with PK UserPWID,autonumber, long;
field ONID,text; field PW, Text;

AND another table called InUsers
InUsersID PK, autonumber, Long
Field ONID, text; Field WebPW, text.

I am trying to update the WebPW with the values in PW where the ONID is the
same in both tables.

Hope this is clear...I am using Access 2007.

Thanks for any help!
Billiam
 
UPDATE InUsers
SET InUsers.WebPW = UserPW.PW
FROM InUsers INNER JOIN UserPW
ON UserPW.ONID = InUsers.ONID

I have not tested it.
-- Dorian
"Give someone a fish and they eat for a day; teach someone to fish and they
eat for a lifetime".
 
Back
Top