两个sql语句要合并成一条，没有多少分数，希望热心人解答

推荐回答

select a.*,B.维修费 from (SELECTTOP(10) convert(varchar(7),GM.CHKTime,120) AS 月份,SUM(GM.Amount_Out) AS 送货安装费,SUM(G_Trade_TradeList.RcvTotal) AS 订单总额,(SUM(GM.Amount_Out)/SUM(G_Trade_TradeList.RcvTotal)) AS 费用占比FROMG_Money_InOut GM INNER JOIN G_Trade_TradeList ON LEFT(GM.Summary,10) = G_Trade_TradeList.TradeNO WHERE GM.Summary LIKE '%送货安装费%' AND GM.WriteOffType=0) a left JOIN (SELECT convert(varchar(7),CHKTime,120) as 月份,sum(G_Money_InOut.Amount_Out) as 维修费FROM G_Money_InOut WHERE G_Money_InOut.Summary like '%维修费%' AND G_Money_InOut.WriteOffType=0 ) BON A.月份=B.月份