select [姓 名]=a.worker,a.SOUCRE,
[信息条数]=count(*)
from worker_name as a inner Join dove_info b
on a.SOUCRE=b.SOUCRE
group by a.worker,a.SOUCRE
[信息条数]=count(*)
from worker_name as a inner Join dove_info b
on a.SOUCRE=b.SOUCRE
group by a.worker,a.SOUCRE
解决方案 »
- 请教如何用SQL生成商品流水账
- SERVER2000表中如何追加一项为主键。
- SQL2005如何啟動,當本機(NT 2003)的Administrator密碼修改后
- 关于sql server 2000 varchar 使用单引号的奇怪问题
- 遇到问题了,谁帮帮我
- 数库库由mssql05改为2000后报错:在连接到 SQL Server 2005 时,在默认的设置下 SQL Server 不允许进行远程连接可能会导致此失败
- 本人觉得很难的一句sql
- 关于SQL SERVER2000安装的问题!
- 请问这段代码谁帮我看下,什么字符呢?
- 急救!!!!
- 问一下,我搞一很久也没搞定的问题!
- 如何刪除數字後面無效的“0”? 如“20.0000”變為20,“1.0700”變為1.07
select count(1) as icount,soucre from dove_info group by soucre
) b where a.soucre=b.soucre
a.worker as [姓 名],a.soucre,isnull(count(b.soucre),0) as [信息条数]
from
worker_name a,dove_info b
where
a.soucre*=b.soucre
group by
a.worker,a.soucre
from worker_name W
group by W.worker, W.soucre