A表
---------------------------------------------------------------------------------------------------
FLOWCODE HANDLEUNITCODE COMCODE STATECODE OPRID OPRDATE ZZ CC BB 00 0000001 2008-8-26ZZ CC BB BB 1 ZZ CC BB HB ZZ CC BB C2
-------------------------------------------------------
ZZ CC BH 00 ZZ CC BH C2 ZZ CC BH BH 1ZZ CC BH HB
--------------------------------------------------------
ZZ CC CS 00ZZ CC CS C2 ZZ CC CS CS 1ZZ CC CS HB
-------------------------------------------------------
ZZ CC ZM 00ZZ CC ZM C2 ZZ CC ZM HBZZ CC ZM ZM 1 ------------------------------------------------------------------------------------------------------------------------------
根据OPRID 取 (D_OPR 表,OPRNAM ,DEPTID字段)-----统计A表STATECODE字段下 带1的根据OPRID,OPRDATE。。
OPRID 根据 (D_OPR 表,OPRNAM ,DEPTID字段取值) 输入姓名,部门名,统计出总数
------------------------------------------------------------------------------------------------------------------------------
D_OPR表
----------------------
OPRID OPRNAM DEPTID000001 小王 5
---------------------------
D_DEPT表
-----------------------------
DEPTID DEPTNAM 01 一部
02 二部
.. ..
---------------------------------------------------------------------------------------------------
FLOWCODE HANDLEUNITCODE COMCODE STATECODE OPRID OPRDATE ZZ CC BB 00 0000001 2008-8-26ZZ CC BB BB 1 ZZ CC BB HB ZZ CC BB C2
-------------------------------------------------------
ZZ CC BH 00 ZZ CC BH C2 ZZ CC BH BH 1ZZ CC BH HB
--------------------------------------------------------
ZZ CC CS 00ZZ CC CS C2 ZZ CC CS CS 1ZZ CC CS HB
-------------------------------------------------------
ZZ CC ZM 00ZZ CC ZM C2 ZZ CC ZM HBZZ CC ZM ZM 1 ------------------------------------------------------------------------------------------------------------------------------
根据OPRID 取 (D_OPR 表,OPRNAM ,DEPTID字段)-----统计A表STATECODE字段下 带1的根据OPRID,OPRDATE。。
OPRID 根据 (D_OPR 表,OPRNAM ,DEPTID字段取值) 输入姓名,部门名,统计出总数
------------------------------------------------------------------------------------------------------------------------------
D_OPR表
----------------------
OPRID OPRNAM DEPTID000001 小王 5
---------------------------
D_DEPT表
-----------------------------
DEPTID DEPTNAM 01 一部
02 二部
.. ..
OPRID为操作员ID OPRDATE为操作时间
BH
CS
ZM
根据OPRID,OPRDATE,字段进行统计
OPRID为操作员ID OPRDATE为操作时间
int升星啦,老规矩,散分哦
(select a.STATECODE,a.OPRID,b.OPRNAM,b.DEPTID from A表 a inner join D_OPR b on a.OPRID=b.OPRID)
as aa inner join D_DEPT bb on aa.DEPTID=bb.DEPTID
where aa.STATECODE=0000001
还是没有明白你究竟要统计什么,怎么个统计。XD描述清楚一些哟,最好给个结果的例子,就一目了然了。现在也特别喜欢做sql题了。越复杂越有兴趣。
---------------------------------------------------------------------------------------------------
FLOWCODE HANDLEUNITCODE COMCODE STATECODE OPRID OPRDATE ZZ CC BB 00 0000001 2008-8-26ZZ CC BB BB ZZ CC BB HB ZZ CC BB C2
-------------------------------------------------------
ZZ CC BH 00 ZZ CC BH C2 ZZ CC BH BH ZZ CC BH HB
--------------------------------------------------------
ZZ CC CS 00ZZ CC CS C2 ZZ CC CS CS ZZ CC CS HB
-------------------------------------------------------
ZZ CC ZM 00ZZ CC ZM C2 ZZ CC ZM HBZZ CC ZM ZM ------------------------------------------------------------------------------------------------------------------------------
统计时根据OPRID 取人员 (OPRID存在于D_OPR 表,D_OPR表有OPRNAM ,DEPTID字段)-----
统计出A表为下列内容的条数(分别统计下列4种)
ZZ CC BB BB
ZZ CC BH BH
ZZ ZC CS CS
ZZ CC ZM ZM要求:输入姓名,部门名,统计出总数
------------------------------------------------------------------------------------------------------------------------------
D_OPR表(内容)
----------------------
OPRID OPRNAM DEPTID000001 小王 5
---------------------------
D_DEPT表(内容)-----------------------------
DEPTID DEPTNAM 01 一部
02 二部
.. ..
不知道意思理解的对不对,你试试这个SQL>select a.OPRID, a.FLOWCODE, a.HANDLEUNITCODE, a.COMCODE, a.STATECODE, count(1) count from A, a D_OPR b, D_DEPT c where a.OPRID=b.OPRID and b.DEPTID=c.DEPTID and a.COMCOD=a.STATECODE and b.OPRNAM=&oprname and c.DEPTNAM =&deptname group by a.OPRID, a.FLOWCODE, a.HANDLEUNITCODE, a.COMCODE, a.STATECODE;