Update the values in a table from another table

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
 
D

Dorian

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".
 
Top