union all 后少了括号,而且可以用分行符的=@"select dt_expec,sum(qt_argmet),sum(qt_necess_expec),sum(qt_invent)+sum(qt_argmet)-sum(qt_necess_expec) as total from
(
select '00000000' as dt_expec,0 as qt_argmet,0 as qt_necess_expec,qt_invent from wwgbt322 where CD_FACT='XX'
union all ( select dt_store_expec as dt_expec,qt_argmet,0 as qt_necess_expec ,0 as qt_invent from wwgbt301 where CD_FACT='XX')
union all ( select dt_necess_expec as dt_expec,0 as qt_argmet, qt_necess_expec,0 as qt_invent from wwgbt302 where CD_FACT='XX')
order by dt_expec
)
group by dt_expec
order by dt_expec"
(
select '00000000' as dt_expec,0 as qt_argmet,0 as qt_necess_expec,qt_invent from wwgbt322 where CD_FACT='XX'
union all ( select dt_store_expec as dt_expec,qt_argmet,0 as qt_necess_expec ,0 as qt_invent from wwgbt301 where CD_FACT='XX')
union all ( select dt_necess_expec as dt_expec,0 as qt_argmet, qt_necess_expec,0 as qt_invent from wwgbt302 where CD_FACT='XX')
order by dt_expec
)
group by dt_expec
order by dt_expec"
解决方案 »
- 问一下现在网页网络游戏都是使用什么语言和技术开发的?
- asp.net 页面上有一个按钮怎么样按这个按钮的时候 打开一个文件 比如word 还有其他。路径已经有了。
- AspNetPager的问题
- 【散分】根据时间范围查找数据~~
- 机器安装的Visual Studio2005+SQL2005,现在想升级为Visual Studio2008+SQL2008,需要注意什么吗?
- 关于owc控件运用问题
- 在ASP.NET中用Response.Write输出jacascript为什么会导致css文件无法被调入页面?
- 好像是session过期的问题,请大家看一下
- 如何点击取消按钮后,页面中的确认控件不工作?
- 问下:asp.net是用什么语言写的
- 我编了一个基类,生成了.dll,在一个解决方案的若干个项目引用时,有时候会报这个.dll正被另一个进程引用是怎么回事
- 问题一则
少了括号,而且可以用分行符的
回:括号我加了也没有用啊
分行符,我该怎么处理呢