Hello,
I am having problem to update multiple table with a single value..
Actually have 3 tables named 'imprt','imprt2' and 'temp1'.each table has same field name'tele'
I have to update values of each table...but my query do not work.please can any one help me?
<tag> UPDATE imprt as a,imprt2 as b , temp1 as c SET a.tele = 'd',b.tele = 'd',c.telec = 'd' WHERE a.telec='NEHA' AND b.tele='NEHA' AND c.tele='NEHA'