Mysql连接两个表根据条件获取相同的字段值

Question

我有两张这样的 table

表a

id  email    firstname  lastname
1   a@a.com   xx         xx      
2   b@b.com   xb         ab      

表b

  id     email    firstname   lastname
  1      a@a.com    sd          cx       
  2      c@c.com    df          dr        

我喜欢这个

  email      firstname     lastname

   a@a.com       xx         xx
   b@b.com       xb         ab
   c@c.com       df         dr

任何人都请帮助我。我试过联合，明显没有得到我的结果

Answer 1

你可以试试这个:-

SELECT email, firstname, lastname
FROM table_a
UNION
SELECT email, firstname, lastname
FROM table_b
WHERE email NOT IN (SELECT email FROM  table_a)