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,