Below is a query for your requirment,

UPDATE ISCOLOR

SET ISCOLOR = CASE when COLOR.Blue IS NOT NULL OR COLOR.Red IS NOT NULL or COLOR.Yellow IS NOT NULL then 'Yes' else 'NO' END

FROM ISCOLOR INNER JOIN COLOR ON ISCOLOR.ID = COLOR.ID