Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
topgun2001
Starting Member
1 Post |
 Posted - 2010-09-16 : 20:20:23
|
| Hello all!! Awesome place here.. So i'm new to using sql queries and i'm having some problems.. basically, what I have is 2 tablesarmor and armor_copy both are pretty much identical im trying to figure out the query command for... eh if columna in armor_copy matches columna in armor then it will update columnb in armor with columnb data from armor_copy..lol sorry im sure thats a mess .. hard time finding correct way to explain.. So ty all who responds :) |
|
|
GhantaBro
Posting Yak Master
215 Posts |
Posted - 2010-09-16 : 21:50:40
|
update aset columnb = b.columnbfrom armor ajoin armor_copy bon a.columna = b.columnaquote:
Originally posted by topgun2001
Hello all!! Awesome place here.. So i'm new to using sql queries and i'm having some problems.. basically, what I have is 2 tablesarmor and armor_copy both are pretty much identical im trying to figure out the query command for... eh if columna in armor_copy matches columna in armor then it will update columnb in armor with columnb data from armor_copy..lol sorry im sure thats a mess .. hard time finding correct way to explain.. So ty all who responds :)
|
 |
|
|
|
|
|
Inner join problems...