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.
set Matchcode = (Case When Select Flag.ID
Inner Join Counter
ON Flag.ID = Counter.ID
and flag.flag_code = 'DEL' Then 'Flag DEL')