select tablea.*,bb.jilu from tableA left outer join bb
(select riqi,max(bianhao) as bianhao,sum(jilu) as jilu from tabel2 group by riqi) BB
on tablea.riqi=bb.riqi
(select riqi,max(bianhao) as bianhao,sum(jilu) as jilu from tabel2 group by riqi) BB
on tablea.riqi=bb.riqi
解决方案 »
- 急,如何把.DAT数据文件导入数据库中!
- sql server 简单问题
- 关于模糊查询的问题
- 大侠给看看这个sql啊,对'的用法总是过敏
- 怎么创建这样的表:两个主键均定义成另一个表的主键的外键?
- 各位老大,方案求助,其实挺简单的,进者有分。
- 高手论坛,将数据库里所有的字段里的字符串"ABC"转换为字符串"abc"!
- HELP:怎样从sql server 6.5 向sybase导数据?
- 分页存储过程动态where报错 指定了非布尔类型的表达式
- 求教一触发器问题,请各问高手指点一二,小弟拜谢啦,急用啊!(100分赠送)
- 请问如何取出系统时间,同是过滤到时分秒,我只是需要年月日!
- 触发器中用exec来执行语句,不能访问inserted表,Why?如何处理?
select a.*,sum(b.jilu) as jilu
from table1 a
inner join table2 b on a.riqi=b.riqi and a.bianhao=b.bianhao
group by a.riqi,a.bianhao,a.rongliang
from table1 a ,table2 b
where a.riqi=b.riqi and a.bianhao=b.bianhao
group by a.riqi,a.bianhao
(select sum(jilu)
from T2
where riqi = a.riqi and bianhao = a.bianhao
)
from T1 a