SQL从同一列收集数据，可能会产生不同的结果

The problem I am currently experiencing is that if the Contact.email are different then it displays both as NULL. If I use OR instead of AND it acquires both of the emails but in different rows, so they are duplicated.The problem I am currently experiencing is that