I'm having a hell of a time with a seemingly easy statement. I have verified all the tables and fields are correct
SET [Status] = 'en'
inner JOIN dbo.[tblBNK_GRP_ENT]
ON ACH_1114b.[account number] = tblBNK_GRP_ENT.ACCT
WHERE ACH_1114b.[Status]='EN' AND tblBNK_GRP_ENT.GroupedPmts = 0
the error i get is Msg 156, Level 15, State 1, Line 9
Incorrect syntax near the keyword 'inner'.