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
Results 1 to 2 of 2
Thread: Syntax error....Threaded View
|
|
|