mysql多表查询实例结果及分析-2017.12.14
set @bgDate = '20171213';set @edDate = '20171213';
/*编号①*/
SELECT TA_ID,SUM(TB.amount),SUM(TB.fee) FROM
(SELECT ORDER_NO,TA_ID FROM Table_AWHERE 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`
WHERETA.`SETTLE_DATE` >= @begDate AND TA.`SETTLE_DATE`
页:
[1]