I am quite new to SQL. Could you please help me with the error.
Thanks!

UPDATE ztblEncounterApprovalStatus SET iEncounterApprovalStatusId=2 FROM (SELECT max(EAS.iEncounterApprovalStatusId) as iEncounterApprovalStatusId             FROM             dbo.ztblEncounterApprovalStatus EAS inner join             dbo.tlkpApprovalStatus E       on E.iApprovalStatusId = EAS.iApprovalStatusId GROUP BY iEncounterId WHERE iEncounterID = 6)

Go to the complete details ...