Thanks for reply,

Your script returned Y for all WEBCAST1...4

Actaully this one worked.

SELECT DISTINCT fname, lname, email,


max((CASE when web_cast_id = 1 then 'Y' else 'N' end)) AS WEBCAST_1,

max((CASE when web_cast_id = 2 then 'Y' else 'N' end)) AS WEBCAST_2,

max((CASE when web_cast_id = 3 then 'Y' else 'N' end)) AS WEBCAST_3,

max((CASE when web_cast_id = 4 then 'Y' else 'N' end)) AS WEBCAST_4


FROM marketing_leads.web_cast

group by fname, lname, email



Thanks for your help