Update or?

• SteveH2455

  SSC Enthusiast

  Points: 162

  More actions

  October 31, 2003 at 11:24 pm

  #160341

  Hi, I'm quite new to SQL and could use your help please.

  In my database I have 2 tables that hold unique values, and I need to 'Map' all these values from one table to a single value in the other table. Obviously if I do a normal update statement, then I can't enter another value the same?

• mightyjoemad

  Mr or Mrs. 500

  Points: 586

  More actions

  November 3, 2003 at 7:54 am

  #480640

  you can use an update of all the fields except for the Key value.

  Can say

  update table set ....

  where key_table1 = key_table2