try Oracle的没弄过。试试看吧!SELECT g.game_name as gameName , nvl(SUM(s.sales_count), 0) TotalSaleCount , nvl(SUM(s.sales_total), 0) TotalSales , nvl(SUM(s.m_sales_commission_amount), 0) TotalSalesCommission , nvl(SUM(s.payout_count), 0) PayoutAmount , nvl(SUM(s.payout_total), 0) TotalPayout , nvl(SUM(s.m_payout_commission_amount), 0) TotalPayoutCommission FROM merchant_per s , mer m, game g WHERE s.game_id IS NOT NULL AND s.merchant_id = m.merchant_id AND m.parent_id = 1 AND g.game_id = s.game_id GROUP BY g.game_name
nvl(SUM(s.sales_count), 0) TotalSaleCount ,
nvl(SUM(s.sales_total), 0) TotalSales ,
nvl(SUM(s.m_sales_commission_amount), 0) TotalSalesCommission ,
nvl(SUM(s.payout_count), 0) PayoutAmount ,
nvl(SUM(s.payout_total), 0) TotalPayout ,
nvl(SUM(s.m_payout_commission_amount), 0) TotalPayoutCommission
FROM merchant_per s ,
mer m,
game g
WHERE s.game_id IS NOT NULL
AND s.merchant_id = m.merchant_id
AND m.parent_id = 1
AND g.game_id = s.game_id
GROUP BY g.game_name
谢谢,经过这一优化后,快多了