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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-02-05 : 16:19:53
|
Ross writes "I can execute the Update Query below with Access 97 attached to a SQL Server 7 database (I used the Upsize Wizard) no problem. However I cannot use it either in my ASP page or as a stored procedure. It seems that SQL Server does not like the INNER JOIN to be before the WHERE or FROM clause. Trouble is, I do not know of a way of changing the query to comply with this and still do the same job. Any ideas?
UPDATE DISTINCTROW Questions_remote INNER JOIN Responses_remote ON Questions_remote.QuestionID = Responses_remote.QuestionID
SET Responses_remote.Response_Active = 0
WHERE Responses_remote.SurveyID= 249
AND Questions_remote.Parent_QuestionID= 124;" |
|
|
|
|
|
UPDATE with INNER JOINS