query

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • priyankanair
    New Member
    • Aug 2007
    • 1

    query

    hi ...
    how do i use a field say user_id in my USER table in another table say PRODUCT?
  • azimmer
    Recognized Expert New Member
    • Jul 2007
    • 200

    #2
    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.

    Comment

    • ak1dnar
      Recognized Expert Top Contributor
      • Jan 2007
      • 1584

      #3
      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.

      Comment

      Working...