如何在sql server中的第二个连接表中使用distinct

I have a SQL table consists of id, name, email,.... I have another SQL table that has id, email, emailstatus but these 2 id are different they are not related. The only thing that is common between these 2 tables are emails.I have a SQL table consists of id, name, email,