Spot the incorrect syntax..! 2

[chewyone]

With the below code, I keep on getting the following error:

Server: Msg 170, Level 15, State 1, Line 1
Line 1: Incorrect syntax near '('.

Can anyone spot the problem please..?! Thanks!

UPDATE ((APTLive.dbo.Person INNER JOIN APTLive.dbo.Employee
ON APTLive.dbo.Person.PersonUID = APTLive.dbo.Employee.PersonUID)
INNER JOIN APTLive.dbo.Employer ON APTLive.dbo.Employee.EmployerUID = APTLive.dbo.Employer.EmployerUID)
INNER JOIN APTLocal.dbo.[User] ON APTLive.dbo.Person.PersonUID = APTLocal.dbo.[User].PersonUID
SET APTLocal.dbo.[User].PersonUID = "999999"
WHERE APTLive.dbo.Employer.EmployerUID= '1252191';

 

[Mercury2]

Take out all the parens. and give it a new try.

 

[chewyone]

I had it all wrong... I took it from Access to SQL so a few adjustments were needed.

This worked perfect:

UPDATE APTLocal.dbo.[User]SET PersonUID = '999999'
FROM ((APTLive.dbo.Person INNER JOIN APTLive.dbo.Employee
ON APTLive.dbo.Person.PersonUID = APTLive.dbo.Employee.PersonUID)
INNER JOIN APTLive.dbo.Employer ON APTLive.dbo.Employee.EmployerUID = APTLive.dbo.Employer.EmployerUID)
INNER JOIN APTLocal.dbo.[User] ON APTLive.dbo.Person.PersonUID = APTLocal.dbo.[User].PersonUID
WHERE APTLive.dbo.Employer.EmployerUID= '1252191';

 

[Ascalonian]

Good job figuring it out on your own!

 

[r937]

spot the incorrect syntax?

well, for starters, [User] might be valid in both Access and SQL Server, but it's invalid in the language of this particular forum

;-)

r937.com | rudy.ca

 

[JarlH]

The number one tool for finding bad/non-standard syntax is the Mimer SQL Validator:

http://developer.mimer.com/validator/

Online verification of SQL-92, SQL-99, and SQL-2003 compliance.