正文sqlserver 查询 inner join 同一表2次 只出一条查询结果IP云V管理员/2022-08-23/6 阅读 08/23提示:扫一扫查出行【扫一扫了解最新限行尾号】复制提示 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