select *,(select CarrierID from tt where CarrierID=1 and IsMainCarrier=0),
(select CarrierID from tt where CarrierID=2 and IsMainCarrier=0),
from tt where IsMainCarrier=1
格式要固定才行
select * from 查询7 a left join 查询5 b on a.bh=b.bh
查询5
TRANSFORM max(CarrierID)
SELECT bh
FROM [SELECT 1 as bh ,CarrierID from tt where IsMainCarrier=1]. AS [%$##@_Alias]
GROUP BY bh
PIVOT iif(CarrierID=3,'主载波','第二辅载波');
查询7
TRANSFORM max(CarrierID)
SELECT bh
FROM [SELECT 1 as bh ,CarrierID from tt where IsMainCarrier=0]. AS [%$##@_Alias]
GROUP BY bh
PIVOT iif(CarrierID=1,'第一辅载波','第二辅载波');