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 ...