mysql多表查询实例结果及分析-2017.12.14

yes-no

set @bgDate = '20171213';　　
set @edDate = '20171213';
　　

　　
/*编号①*/
　　
SELECT TA_ID,SUM(TB.amount),SUM(TB.fee) FROM
　　
(SELECT ORDER_NO,TA_ID FROM Table_A  WHERE TA_STATUS = 100 AND TA_CHANNEL_MERCH_NO = '201712130001'
　　
AND SETTLE_DATE = @begDate )TA
　　
LEFT JOIN
　　
(SELECT ORDER_NO,AMOUNT,fee FROM Table_B) TB
　　
ON TA.ORDER_NO = TB.ORDER_NO
　　
GROUP BY TA.TA_ID;
　　

　　
/*编号②*/
　　
SELECT TA.`TA_ID` AS TA_ID , sum(TA.`AMOUNT`)  AS sumAmount , sum(TB.`fee`)   AS sumMerFee FROM
　　
`Table_A` TA
　　
LEFT JOIN
　　
`Table_B` TB
　　
ON TA.`ORDER_NO` = TB.`ORDER_NO`
　　
WHERE  TA.`SETTLE_DATE` >= @begDate AND TA.`SETTLE_DATE`