can we insert in multiple tables with one insert command [message #223615] |
Fri, 09 March 2007 15:35 |
AGARWALNIRU
Messages: 13 Registered: March 2007
|
Junior Member |
|
|
hi
I am performing some rigourous data insertion
heres the snap shot of the psuedo code
Insert valid_email records and Timestamp into User and Application_User_Account tables
Where Email_address not in User table AND Account_id exists in Account AND Account_id exists in
Application_User_Account (accomplished with full outer join on User, Account, and
Application_User_Account tables)
from the valid_email i have to insert 3 diff cols in user table and other 3 in application_user_account
I would really appriciate your help..........thanks!!
|
|
|
|