sql语句问题
SQL code:
select b.subprjid,sum(b.achieve) as lastachieve,sum(b.material) as lastmaterial,sum(b.due) as lastdue
,sum(isnull(CAST(b.dkkcl AS FLOAT),0)) as lastdkkcl
,sum(isnull(CAST(b.dkkfk AS FLOAT),0)) as lastdkkfk
,sum(isnull(CAST(b.dkksdf AS FLOAT),0)) as lastdkksdf
,sum(isnull(CAST(b.dkkst AS FLOAT),0)) as lastdkkst
,sum(isnull(CAST(b.dkkqt AS FLOAT),0)) as lastdkkqt
,sum(isnull(CAST(b.other AS FLOAT),0)) as lastother
,sum(isnull(CAST(b.obligate AS FLOAT),0)) as lastobliget
,sum(isnull(CAST(a.achieve AS FLOAT),0)) as yearachieve
,sum(isnull(CAST(a.material AS FLOAT),0)) as yearmaterial
,sum(isnull(CAST(a.due AS FLOAT),0)) as yeardue
from t_subcontract_subfinishproduction as b,t_subcontract_subfinishproduction as a
where b.subprjid='EB2009050412398898142851954589888' and b.yyyy+'-'+b.mm<'2010-01' and a.yyyy='2010' and a.subprjid='EB2009050412398898142851954589888'
group by b.subprjid
上面的语句查询的时候，查询b里面是有数据的，而a里面没有数据，这种情况就会搞的最后显示的表中都没有数据了，怎么解决啊？
or a.yyyy='2010'
where b.subprjid='EB2009050412398898142851954589888' and b.yyyy+'-'+b.mm <'2010-01' and a.yyyy='2010' and a.subprjid='EB2009050412398898142851954589888'
group by b.subprjid
改为：
where (b.subprjid='EB2009050412398898142
相关问答：
大家帮忙看看这2个sql语句哪个查询的速度更快点。谢谢帮忙。比较着急。在做性能测试。
select * from
表A LEFT OUTER JOIN 表B ON (表A.id || ' ' =表B.id) ,表C , 表D, 表E
Where其他条件
select * ......
我一个项目，有个插入操作，具体是这样的：
我有进货信息表。在出货时选择相应的进货信息，输入数量，选择部门后，点保存按钮，由于网络延时，点一下没有反映，于是用户就又点一下，导致一次插入了两条记录:
例：
......
我要得到一个字符串如：
sdfk|||sgts
sdfsfd|||rgreg
wrfw|||sefw
就是要得到|||后面的字符串，有什么函数吗？怎么用呢？谢谢！
SQL code:
select
right(col,len(col)-charindex('|||',col)-2)
f ......
<table style="width: 1000px"><tr>
<td style="height: 38px; width: 35px;">
姓名</td>
......
小弟，最近要转行去做oracle开发了，由于大学毕业时，走了个弯路，现在很小心，问下，做PL/SQL有没有前途？？？
当然我说的这个前途是指 以后要跳槽，市场对这样的人才的需求量大不大？？
3q 那看来还只能先接� ......
