hi.....

i have the query like this....

update ttt t
set (t.name,t.refid) = (select (tr.name,tr.ref_id) from tree tr where tr.id=t.id);


Is this possible in mySQL? If possible means . .wat is the syntax error in this query.


Thanks
S.Ashokkumar