Hi All,

When I execute the following line of code to update a table, I get an error. Can someone please tell me what am I doing wrong here.

Thanks

update Counter
set Matchcode = (Case When Select Flag.ID
From Flag
Inner Join Counter
ON Flag.ID = Counter.ID
and flag.flag_code = 'DEL' Then 'Flag DEL')