You can try something like this to check if the value is red or not:

SELECT item.Item_ID AS ItemName,
    CASE 
        WHEN EXISTS (SELECT 1 FROM Options optns WHERE optns.Item_ID = item.Item_ID AND optns.Color = 'Red') THEN 'Y'
        ELSE 'N'
    END AS IsRedOrNot FROM Items item;