hi friends,

I want to write a query like this

update organisation
set tandctext = (Select tandctext from organisation where nodeid=144)
where nodeid=5555;

but i am getting an error..please friends can u help regarding this issue in
Mysql4.0.26 and MySql5.0 versions please.


waiting for ur replies

Bye...

either do it in two steps, or use a multi-table update query with a join (examples on the mysql.com site under the UPDATE syntax)