[zPain]

Try this:

Код:

UPDATE houses INNER JOIN useraccounts ON houses.username = useraccounts.username SET userid = useraccounts.userid