SQL语言中,A库和B库以(地址,姓名)查重,重复数据留A库的数据,命令是啥?

Question

如题所述

Answer 1

select p.*
from (select A.add as q, A.nme as w, B.add as e, B.nme as r,
from A
left join B on A.add = B.add
and A.nme = B.nme) p
where p.e <> '';