如果有任何重复的值，你不想只使用不同的。





例如，如果有重复的电话号码：

if there are any duplicated values that you don't want just use the distinct.


example if there are duplicates phone numbers make:

select distinct (T1.PhoneNumber) ,T2.City,T2.UniqueId,T2.RefId
From Table1 T1
Inner Join Table2 T2
on T1.RefId = T2.RefId