Inser Auto generated column into another table

Question

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,