Your question, your audience. Choose who sees your identity—and your question—with question security.
Any suggestions
UPDATE PMGTask A
SET A.FK_PMGProjectID = (SELECT
B.PK_PMGProjectID
FROM PMGProject B WHERE B.Number = A.FK_PMGProjectID)
Msg 102, Level 15, State 1, Line 86
Incorrect syntax near 'A'.
Msg 156, Level 15, State 1, Line 92
Incorrect syntax near the keyword 'FROM'.
SET A.FK_PMGProjectID = (SELECT
B.PK_PMGProjectID
FROM PMGProject B WHERE B.Number = A.FK_PMGProjectID)
Msg 102, Level 15, State 1, Line 86
Incorrect syntax near 'A'.
Msg 156, Level 15, State 1, Line 92
Incorrect syntax near the keyword 'FROM'.
Asked:
3
2
1 Solution
Try this:
UPDATE PMGTask As A INNER JOIN PMGProject AS B ON B.Number = A.FK_PMGProjectID
SET A.FK_PMGProjectID = B.PK_PMGProjectID
Access's implementation of SQL is a little weird when it comes to UPDATEs...
Jeff
UPDATE PMGTask As A INNER JOIN PMGProject AS B ON B.Number = A.FK_PMGProjectID
SET A.FK_PMGProjectID = B.PK_PMGProjectID
Access's implementation of SQL is a little weird when it comes to UPDATEs...
Jeff
Whoops! I got here via Microsoft > Development > MS Access > Queries (SQL), so I mistakenly assumed that this forum was Access-specific. For SQL Server and other RDBMSes, angelIII is quite correct. My apologies for being a dunce!
Jeff
Jeff
JTennessen: no worries. the question is actually cross-posted to the 2 zones.
the error message in fact indicates "clearly" that's sql server and not access...
the error message in fact indicates "clearly" that's sql server and not access...
Question has a verified solution.
Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.
Have a better answer? Share it in a comment.
Join & Write a Comment Already a member? Login.
Featured Post
Tackle projects and never again get stuck behind a technical roadblock.
Join Now
UPDATE PMGTask
SET FK_PMGProjectID = B.PK_PMGProjectID
FROM PMGTask A
JOIN PMGProject B
ON B.Number = A.FK_PMGProjectID