
两条查询语句
select salesName, sum(extendedPrice) as sumprice13 from tableSales where salesTime between '2013-01-01' and '2013-12-31' group by salesName
select salesName, sum(extendedPrice) as sumprice14 from tableSales where salesTime between '2014-01-01' and '2014-12-31' group by salesName
如何把查询结果合并成 salesName, sumprice13, sumprice14 呢?
------解决方案--------------------
SELECT
*
FROM
(SELECT
salesName, SUM(extendedPrice) AS sumprice13
FROM
tableSales
WHERE
salesTime BETWEEN '2013-01-01' AND '2013-12-31'
GROUP BY
salesName) AS a
INNER JOIN (SELECT
salesName, SUM(extendedPrice) AS sumprice14
FROM
tableSales
WHERE
salesTime BETWEEN '2014-01-01' AND '2014-12-31'
GROUP BY
salesName) AS b ON a.salesName=b.salesName