Inser Auto generated column into another table

neel k

11y1.1k

Hi,

I need to insert one table auto generated column into another table.

table names:

tbl_application

columns: app_id ,app_name, Description (primary key: app_id, auto generated column)

tbl_users

columns: user_id, user_name (primary key: user_id, auto generated column)

tbl_ applicationusers

columns: id, app_id, user_id

I need to insert tbl_applivation.app_id, tbl_users.user_id into tbl_applicationusers.

thanks,

10 Replies

Know the answer? Post it — somebody with the same question will find it here.

neel k11y ago
it is inserting only max values. i need to insert different combinations of user_id, app_id, I deleted MAX keyword but its not inserting. I gave unique key constraint for both columns
0
Sri Rama Phani Bhushan11y ago
ok.
0
Sri Rama Phani Bhushan11y ago
ok.
0
neel k11y ago
its working,thanks
0
Sri Rama Phani Bhushan11y ago
Use stored Procedure insert query asusal select @Maxappid= Max(app_id) from tblApplication Select @Maxuserid = max(User_id) from tblusers insert into tbl_applicationusers(Coulumnnames) values(Maxappid,Maxuserid) once check the syntax
0
neel k11y ago
Hi, thanks for your reply. can you please give me the query.
0
Sri Rama Phani Bhushan11y ago
You can use two insert statements at a time and before the second insert you can query and get the max id of the first table...
0
Sri Rama Phani Bhushan11y ago
You can use two insert statements at a time and before the second insert you can query and get the max id of the first table...
0
Sri Rama Phani Bhushan11y ago
You can use two insert statements at a time and before the second insert you can query and get the max id of the first table...
0
Sri Rama Phani Bhushan11y ago
Hi neel, You can use two insert statements at a time and before the second insert you can query and get the max id of the first table...
0