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
How to insert and update a row in two different tables?
Moderator: General Moderators
-
Mark Baker
- Forum Regular
- Posts: 710
- Joined: Thu Oct 30, 2008 6:24 pm
Re: How to insert and update a row in two different tables?
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
OR
A trigger on the first table that automatically updates the second