mysql> INSERT INTO list_email   (fname, lname, email_addr) SELECT ins.* FROM   ( SELECT 'bob' AS fname,             'schmoe' AS lname,             'bogus@bogus.com' AS email_addr     FROM dual   UNION ALL     SELECT 'mary', 'lamb', 'hoe@me.com'     FROM dual   ) AS ins WHERE NOT EXISTS       ( SELECT 1          FROM list_email AS e          WHERE e.email_addr = ins.email_addr       )   AND NOT EXISTS       ( SELECT 1         FROM list_no_email AS ne          WHERE ne.email_addr = ins.email_addr       );
Query OK, 1 row affected (0.00 sec)
Records: 1  Duplicates: 0  Warnings: 0