I'm new to this db and have one problem.

I have 2 tables:
Table1(T1ID - PK, ...) 
Table2(T2ID - PK, T1ID - FK,... )

How can I insert data into both tables at once 
or at least can I know PK (if it is autoincrement) after insert?

Now I have to do this:
Insert into Table1(...) values (...)
Select T1ID from Table1 where ...
Insert Table2(T1ID,...) values (T!ID,...)


Thnx


_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general

Reply via email to