using UPDATE function and joing tables

[OwenTheSamoan]

I would like to use the UPDATE function and use the WHERE fuction with two seperate tables.

EXAMPLE:
UPDATE tableONE set column A = 'skippy' where tableTWO.userid = tableONE.userid ;

Is something like this possible where you can join two tables and update one? Am I totally off?

Thanks for any help.

[Drakla]

I can't think of a one SQL solution to this but just reverse engineer these two queries that I use to restock one table (stocktab) from another (orderlimbo).

create temporary table tempy AS 
SELECT stocktab.stockid,stocktab.stocklev+orderlimbo.stocklev FROM stocktab, orderlimbo WHERE stocktab.stockid=orderlimbo.stockid;

REPLACE stocktab SELECT * FROM tempy;

Temporary tables are never anything to worry about name wise as they're particular to that thread, so if you had 100 running concurrently all creating a table with the same name they'd not actually clash.

[OwenTheSamoan]

Thanks a lot!!!