Sorry for not explain well. I mean update more than one table at the same time with something like this:
update table1, table2 set table1.f1 = 'aaa', table2.date = '2001-01-01' where table1.id = 'x1' and table2.id = 'x1' Something like this is possible? It is the best way to do it? Best Regards, On Sun, Nov 7, 2010 at 3:11 PM, Scott Ribe <scott_r...@killerbytes.com>wrote: > On Nov 7, 2010, at 7:58 AM, Andre Lopes wrote: > > > need to update various tables in the same update. It is possible to do > it? > > Transactions??? > > -- > Scott Ribe > scott_r...@elevated-dev.com > http://www.elevated-dev.com/ > (303) 722-0567 voice > > > > >