case statement

[chrisrlong]

Try:

SELECT 
   fname, 
   lname, 
   email,
   CASE WHEN SUM(CASE WHEN web_cast_id = 1 THEN 1 END) = 0 THEN 'N' ELSE 'Y' END WEBCAST_1,
   CASE WHEN SUM(CASE WHEN web_cast_id = 2 THEN 1 END) = 0 THEN 'N' ELSE 'Y' END WEBCAST_2,
   CASE WHEN SUM(CASE WHEN web_cast_id = 3 THEN 1 END) = 0 THEN 'N' ELSE 'Y' END WEBCAST_3,
   CASE WHEN SUM(CASE WHEN web_cast_id = 4 THEN 1 END) = 0 THEN 'N' ELSE 'Y' END WEBCAST_4
FROM 
   marketing_leads.web_cast
GROUP BY
   fname, 
   lname, 
   email

- Chris