我有以下MySQL查询: FROM (SELECT a.aid, a.vidINNER JOIN aid2vid a USING(vid)重复了两次,从explain这个MySQL语句中,我没有看到MySQL重用查询结果。+---------+---------+----------+------+--------
这是一个巨大的怪物,它将进入SP,所以变量是可用的: SUM(PaidForPast) AS PaidPast, SUM(PaidForPresent) AS PaidPresent, SUM((AmountPaid - PaidForPast - PaidForPresent)) AS PaidFuture, [Description] FROM (