sqlserver 查询 inner join 同一表2次 只出一条查询结果
时间:2022-03-14 02:30
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