两句SQL并一句,有问题. - MS-SQL Server / 基础类
第一句:
select ht.gfdm,gfdm.gfmc,gfdm.lb ,sum(jh.htdj*jh.htsl)as je
from ht left join gfdm on ht.gfdm=gfdm.gfdm
join jh on ht.htbh=jh.hth
and ht.htbh not like'del%' and ht.ht_xy_flag='ht'
and ht.lkc_flag=0 and jh.hth<>'cancel' and jh.id=ph
and ht.qdrq between '2008-01-01' and '2008-12-31'
group by ht.gfdm ,gfdm.gfmc,gfdm.lb order by je desc
第二句:
select ht.gfdm,gfdm.gfmc,gfdm.lb, sum(ysd.yssl*ysd.htdj)as je
from ht left join gfdm on ht.gfdm=gfdm.gfdm
join ysd on ht.htbh=ysd.htbh
and ht.htbh not like'del%' and ht.ht_xy_flag='ht'
and ht.lkc_flag=1
and ht.qdrq between '2008-01-01' and '2008-12-31'
group by ht.gfdm ,gfdm.gfmc,gfdm.lb order by je desc
合并
select ht.gfdm,gfdm.gfmc,gfdm.lb,
je=sum(case ht.lkc_flag when 0 then jh.htdj*jh.htsl else 0 end)
,lkc_je=sum(case ht.lkc_flag when 1 then ysd.yssl*ysd.htdj else 0 end)
from ht left join gfdm on ht.gfdm=gfdm.gfdm
join ysd on ht.htbh=ysd.htbh
join jh on ht.htbh=jh.hth
where ht.qdrq between '2008-01-01' and '2008-12-31'
and ht.htbh not like'del%' and ht.ht_xy_flag='ht'
group by ht.gfdm ,gfdm.gfmc,gfdm.lb order by je desc
我把两句前两句并成一句后,结果不对.请高手帮助诊断一下,错在哪里,谢谢!
select ht.gfdm,gfdm.gfmc,gfdm.lb ,sum(jh.htdj*jh
相关问答：
从数据库中查询一张表的数据
select 部门,姓名 from tb
如何才能生成下面的xml格式
XML code:
<folder state="unchecked" label="全部">
<folder state="unchecked&qu ......
protected void btnLogin_Click(object sender, EventArgs e)
{
SqlConnection conn = new SqlConnection("Server = (local);user id = sa;pwd = 1;database = Login");
&nb ......
小弟，最近要转行去做oracle开发了，由于大学毕业时，走了个弯路，现在很小心，问下，做PL/SQL有没有前途？？？
当然我说的这个前途是指 以后要跳槽，市场对这样的人才的需求量大不大？？
3q 那看来还只能先接� ......
想用SQL CLR做如下的存储过程,但是发现报错:
{由于代码已经过优化或者本机框架位于调用堆栈之上，无法计算表达式的值。}
而且如果数据从case 1通过时就是正确的,从case 2通过时错误
并且在c ......
select count(1) from FX_RETURNBOOKCHECKLIST fxreturnbo0_ where fxreturnbo0_.BOOKID='164 ' AND fxreturnbo0_.RETURNID='00025.S0000001'
上面一个简单的SQL,执行时间2.6� ......
