Via SQL Enterprise manager, I'm trying to use a view in a join update and
get SQL error "Msg 156, Level 15, State 1 - Incorrect syntax near the
keyword 'INNER'".
The syntax is
UPDATE TableName INNER JOIN ViewName
ON Tablename.Key = ViewName.Key
SET ...
Anybody know what at's wrong here?
Thanks in advance,
Joe Foster