Missing Operator Error in Update Statement 1

[kshanes]

Good morning,

I'm trying to update a column in 1 table based on information in 2 other tables. No matter how I format the SQL I keep getting the error: "Syntax Error (Missing Operator) in Query Expression 'UsersAndGroups.ACL FROM ConsolidateGroups'. The actual statement is below. Any help would be appreciated.
------------------------------------------------
Update ConsolidateGroups
SET ConsolidateGroups.ACL= UsersAndGroups.ACL
FROM ConsolidateGroups,
UsersAndGroups,
UserCounts
WHERE UserCounts.TotalACLs = 1
and UsersAndGroups.[Logon Name] = UserCounts.[Logon Name]
and ConsolidateGroups.CorpId = UsersAndGroups.[Logon Name]
---------------------------------------------------
Thanks in advance for any help.

 

[lupins46]

I have not looked at the logic of the query but the syntax should be:

Update ConsolidateGroups,UsersAndGroups, UserCounts
SET ConsolidateGroups.ACL= UsersAndGroups.ACL
WHERE UserCounts.TotalACLs = 1
and UsersAndGroups.[Logon Name] = UserCounts.[Logon Name]
and ConsolidateGroups.CorpId = UsersAndGroups.[Logon Name]

Make sure you have a backup when you test this.