If you are using mysql the below query should work. update Table_1,Table_2 set Table_1.sex='1',Table_2.Religion='1';
In sql server, you can go ahead with stored procedure using the below query begin transaction update the first table if @@Error<> 0 goto RBack update the second table if @@Error<>0 goto RBack commit transaction RBack: Rollback transaction I hope it'll solve ur problem. On Mon, Nov 3, 2008 at 9:27 PM, BigJ <[EMAIL PROTECTED]> wrote: > > Is it possible to do an update on multiple tables within 1 statement?
