UPDATE from field in other table

[lemarsu]

I have written some SQL but it would not work under mysql (in the office DB2 and oracle are ok with this kind of sql)

 

the following sql is what I am trying to run :

 

 

UPDATE tableA, tableB

SET tableA.usergroupid=8

WHERE 

 tableB.userid= tableA.userid AND

 tableB.country= \'United Kingdom\' AND

 tableA.usergroupid=\'5\'

 

 

Can anyone please help....

 

Thanks

LeMarsu

[Kriek]

Starting with MySQL Version 4.0.4, you can also perform UPDATE operations that cover multiple tables

 

You need MySQL 4.0.4 to perform the query [link]