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 |
|
makimark
Starting Member
34 Posts |
 Posted - 2001-07-21 : 07:57:48
|
| HiI'm trying to update table1 from data found in table2. My problem is that the darn statement when executed updates all records and not just the ones that it should. I have included a where statement. Any ideas ?Update Table1set name = (Select name from table2where table1.name = table2.name)this will update the name=name field but sets all other fields in table1 to null. ???? |
|
|
|
|
|
Updating table from another table