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_ribe(at)killerbytes(dot)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_ribe(at)elevated-dev(dot)com
> http://www.elevated-dev.com/
> (303) 722-0567 voice
>
>
>
>
>