I would like to return only 2 fields but one of the fields is coming from 3 fields.
Select e.uniqueid, e.email from dbo.email e, dbo.unsubscribe u where e.email is not null and e.email = u.email and u.email_unsubscribe = 'Y'
field (email): if email1 is not null then email1, if email2 is not null then email2, if email3 is not null then email3 else ''
I am looking to only pull one email per identifier that is not on the unsubscribe list. Email1 should always be used first then email2 then email3