inner join T_MTN_MobileNumber k on 1=1 and k.hddm=‘01‘
inner join (select a.hdxx+‘,‘+b.hdxx as hdxx from T_MTN_MobileNumber a
cross join T_MTN_MobileNumber b where a.hddm=‘02‘ and b.hddm=‘03‘) m on 1=1
sqlserver 查询 inner join 同一表2次 只出一条查询结果
原文：http://www.cnblogs.com/miraclesakura/p/4097395.html