emails.sql

CREATE VIEW emails AS (
  SELECT email FROM users
    UNION
  SELECT other_email AS email FROM more_users
    UNION
  select other_other_email AS email FROM even_more_users
);

SELECT 1 FROM emails WHERE email = 'email@email.com';