select (select sum(GSUNMONEY) from gwyx_BankDic)as Lh_Qcz2,sum(gwyx_Financing_sumrept.GREVENUE) as Lh_sr,sum(gwyx_Financing_sumrept.GPAYOUT) as Lh_zc from gwyx_Financing_sumrept inner join gwyx_zjrb_MTREN on gwyx_zjrb_MTREN.MRPTDATE=gwyx_Financing_sumrept.GRPTDATE where gwyx_Financing_sumrept.GRPTDATE='2002-9-22' and gwyx_zjrb_MTREN.GSIGN is not null
解决方案 »
- 折磨半天,找不出原因
- 数据库内容乱码。有办法修改吗
- 我表里的有条记录不知道怎么丢失了,我想恢复下,怎么做!
- 如何用语句修改字段id属性 设它为主键且自动增一
- VB的select case语句替换成SQL Server的简单case函数,怎么写?
- SQL时间差算法求救。
- MS SQL Server7.0升级到MS SQL Server 2005
- 远程调用存储过程的问题,在查询分析器中好用,但放到触发器中,执行增加时,会出现超时错误?
- 触发器里不能使用链接服务器(LinkedServer)吗?
- 求赐予一SQL排序语句,超难
- "[Microsoft][ODBC SQL Server Driver]连接占线导致另一个 hstmt",请问这是什么引发的错误?
- 请问怎样在sql语句中,设置数据库的一些参数呀
((select sum(GSUNMONEY) as Lh_Qcz2 from gwyx_BankDic)) as a,
(select sum(gwyx_Financing_sumrept.GREVENUE) as Lh_sr,
sum(gwyx_Financing_sumrept.GPAYOUT) as Lh_zc
from gwyx_Financing_sumrept
inner join gwyx_zjrb_MTREN
on gwyx_zjrb_MTREN.MRPTDATE=gwyx_Financing_sumrept.GRPTDATE
where gwyx_Financing_sumrept.GRPTDATE='2002-9-22'
and gwyx_zjrb_MTREN.GSIGN is not null) as b