Click here to Skip to main content
15,790,135 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
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'


1 solution

You can not update multiple tables in single statement.Rather than you can group all updates in a single procedure and execute the procedure within transaction or you can batch up all the updates.
Share this answer
project virus 28-Feb-13 1:45am    
Can't I do it by using JOIN?
Shubhashish_Mandal 28-Feb-13 2:15am    
In this case you can't.
kimberly wind 28-Feb-13 4:55am    
Shubhashish is correct .cant update multiple database same time .only solution is stored procedure

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900