I am trying to extract all Verizon owned email domains from existing data extensions in SFMC and placing these subscribers into a new DE that will contain only the subscribers who use a Verizon domain.
Select * FROM "Data Ext 1" AND "Data Ext 2" WHERE EmailAddress LIKE '%@aol.com' AND EmailAddress LIKE '%@yahoo.com' AND EmailAddress LIKE '%@netscape.com' AND EmailAddress LIKE '%@verizon.com'
However, this is not working. If I remove the second DE, it still won't extract the domains if I use a LIKE statement, however, if I use a NOT LIKE statement my new DE gets populated with all subscribers who DON'T use a Verizon email domain. Why is it working one way but not the other?