mysql - 比较sql中的两个电子邮件地址？

Question

EG:
table 1: Email Address
         [e-mail]
         [e-mail]
         [e-mail]

table 2: Email Addresses in DB
         [e-mail]
         [e-mail]
         [e-mail]
         user@[e-mail]
         [e-mail]

O/p: table

    Email Address reported    | Match/No match |
         [e-mail]       |NO  match in DB
        [e-mail]       | match in DB
         [e-mail]      |match in DB

请分享完整的 SQL 查询，我可以在其中比较 DB 中匹配的电子邮件地址。在此处输入代码

谢谢！！

标签： mysqlsql

Answer 1

SELECT EmailAddress,
CASE
    WHEN EmailAddress in (select EmailAddress from table2)  THEN 'match in DB'
    ELSE 'NO  match in DB'
END AS 'Match/No match'
FROM table1