SQL QUERY ----检索所有电子邮件

Question

$q="SELECT DISTINCT 
            t1.un_email,t6.email
                   FROM
                   sisters_7sisters.tbl_unsubscribe as  t1,
                   sisters_7sisters.tbl_uptade_list as t6";

I write a query like above I need to retrieve all the unique emails from the tables But it gives me pair of some results which are not unique ..I tried to get the email only once from these tables.

Answer 1

It would be better to use a join to join those two tables and select the distinct email

The distinct you are using, is only applied to each column of the result and not both at the same time.