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 |
|
daniel.newman@bis-web.net
Yak Posting Veteran
71 Posts |
 Posted - 2001-06-28 : 05:03:51
|
| I hope someone can help. I've read the instruction in BOL, but still can't this this simple task to work. I have created a temp table, and I wish to update another table while checking for results in the temp. So I need the two to be joined.Below is what I want to do:UPDATE Users INNER JOIN #UsersLists UL ON Users.UserID = UL.UserIDSET Corporate = 1WHERE UL.List1 = 2 AND UL.List2 = 4But I keep getting the following error: "Incorrect syntax near the keyword 'INNER'."Does anyone know the proper syntax to use here?Thanks,Daniel. |
|
|
|
|
|
Trying to join a temp table to an update statement