Syntax error....

[ashokkumar]

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

[manoj_jnics1]

Hi Mr Ahhok
this is not possible here!
u r comparing two values with one = operator
this is wrong way
which version of mysql r u using?
send ur problem in detail

thanks and regards
manoj