SELECT x.rptYear, x.city,
x.income1, y.income2
FROM
(SELECT a.rptYear, a.city,
SUM(yearIncome) AS income1
FROM lnssoftsaleexport a
WHERE a.prodCode BETWEEN 'E101010101'
AND 'E101010300'
AND a.rptYear >= #startRptYear#
AND a.rptYear <= #endRptYear#
AND a.city = #city#
GROUP BY a.rptYear, a.city) x
LEFT OUTER JOIN
(SELECT b.rptYear, b.city,
SUM(ISNULL(softProdIncome, 0)) AS income2
FROM lnsyrcriterion b
WHERE b.isGov = 0
AND declared = 1
AND b.rptYear >= #startRptYear#
AND b.rptYear <= #endRptYear#
AND b.city = #city#
GROUP BY b.rptYear, b.city) y
ON x.rptYear = y.rptYear
AND x.city = y.city
x.income1, y.income2
FROM
(SELECT a.rptYear, a.city,
SUM(yearIncome) AS income1
FROM lnssoftsaleexport a
WHERE a.prodCode BETWEEN 'E101010101'
AND 'E101010300'
AND a.rptYear >= #startRptYear#
AND a.rptYear <= #endRptYear#
AND a.city = #city#
GROUP BY a.rptYear, a.city) x
LEFT OUTER JOIN
(SELECT b.rptYear, b.city,
SUM(ISNULL(softProdIncome, 0)) AS income2
FROM lnsyrcriterion b
WHERE b.isGov = 0
AND declared = 1
AND b.rptYear >= #startRptYear#
AND b.rptYear <= #endRptYear#
AND b.city = #city#
GROUP BY b.rptYear, b.city) y
ON x.rptYear = y.rptYear
AND x.city = y.city
解决方案 »
- 每天定时调用接口传输5万条数据。这个需要什么技术呢?新手,求思路和关键词~~谢谢
- 求一带变量赋值和sql参数的查询语句
- JDBC下某参数值为中文就是传不到存储过程里去(数据库是SQL2000),但该存储过程可以被正常调用,请教为什么?
- sql server 2k,执行批处理的语句是什么,其中批处理的语句包括GO
- [急]SQL怎么把2行一样的列合并到一行,用“;”隔开?
- 关于动态表查询的问题
- ?修改数据类型?
- 请教一个关于“case when then”的问题
- 根据数量自动生成标签序列号
- 能不能把sql server的数据库转换成access的数据库呢??
- sql server 2005+delphi7 用 联合查询 query1.edit修改查询值 报cannot be modified 错误
- 关于存储过程的效率问题
x.income1, y.income2
FROM
(SELECT a.rptYear
SUM(yearIncome) AS income1
FROM lnssoftsaleexport a
WHERE a.prodCode BETWEEN 'E101010101'
AND 'E101010300'
AND a.rptYear >= #startRptYear#
AND a.rptYear <= #endRptYear#
AND a.city = #city#
GROUP BY a.rptYear) x
LEFT OUTER JOIN
(SELECT b.rptYear
SUM(ISNULL(softProdIncome, 0)) AS income2
FROM lnsyrcriterion b
WHERE b.isGov = 0
AND declared = 1
AND b.rptYear >= #startRptYear#
AND b.rptYear <= #endRptYear#
AND b.city = #city#
GROUP BY b.rptYear) y
ON x.rptYear = y.rptYear