Page 1 of 1

How to insert and update a row in two different tables?

Posted: Wed May 06, 2009 6:38 am
by rameshbyt
Dear friends,

How to insert and update a row in two different tables at a same time?

Insert a row from first table to second table, after the "status field" will update a first table at a same time. Anyone known please help me.


Regards,
R.R.Kumar

Re: How to insert and update a row in two different tables?

Posted: Wed May 06, 2009 7:04 am
by Mark Baker
Two insert statements.... you may also want to start working with database transactions rather than simple inserts
OR
A trigger on the first table that automatically updates the second