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 |
|
phillipsp
Starting Member
5 Posts |
 Posted - 2001-10-16 : 09:36:48
|
| I currently get an "table2 not slelected in query" error when running this. But when i do specify the second table it still errors out. Should this one work? Or should it be written differently? I know this is a basic problem but it is stumping me.update table1 set table1.store = table2.storewhere table1.name = table2.namethanks for any helpPatrick |
|
|
|
|
|
Updating one table from another table