各位大佬们早上好,小弟现有这样的一个问题:
表newMail和表mailAddress,两个表中都有字段mail,如何读出两个表中的所有mail,但不包含重复的mail?
--------------------
newMail:
ID    mail                Flag
1     [email protected]       NULL
2     [email protected]       NULL
3     [email protected]      X
4     [email protected]       NULL
-----------------
mailAddress:
ID    mail                Tag
1     [email protected]      NULL
2     [email protected]       NULL
3     [email protected]       NULL
4     [email protected]       X
----------------------------------
我希望得到的mail是[email protected],[email protected],[email protected],[email protected],[email protected],[email protected]
----------
谢谢各位了,小弟一直在线