query

hi ...
how do i use a field say user_id in my USER table in another table say PRODUCT?

Quote:

Originally Posted by priyankanair

hi ...
how do i use a field say user_id in my USER table in another table say PRODUCT?

At this point it's a bit unclear what you want to do.

If you want to have the same field in both tables you have to define them separately as such when defining the tables. If you already have them defined in both tables and want to use data from both tables at the same time, you have to join the tables. If you want to insert data to a new table, you need to use the proper INSERT statement.

Please provide a bit more info on the context and your goal so that we can help.|||

Quote:

Originally Posted by priyankanair

hi ...
how do i use a field say user_id in my USER table in another table say PRODUCT?

Could you please tell us, what you are trying to do.