帮忙优化一下查询
sw47 2004-09-18 02:04:55 表结构
depid depname itemid itemname totalmoney reportdate docid docname
部门id 部门名称 项目id 项目名称 收入 日期 医生id 医生姓名
部门id对应部门名称 项目id对应项目名称 医生id对应医生名称
日期为该收入的日期
每条记录记录了某个部门的某医生在某天某项目上的收入数额
我的sql语句
rsxm1=STMT1.executeQuery("select distinct itemid,itemname from inhos_oareport where reportdate between '"+stime+"' and '"+etime+"' order by itemid");
rsxm2=STMT2.executeQuery("select distinct itemid,itemname from clinic_oareport where reportdate between '"+stime+"' and '"+etime+"' order by itemid");
rsks1=STMT3.executeQuery("select distinct depid,depname from inhos_oareport where reportdate between '"+stime+"' and '"+etime+"' order by depid desc");
rsks2=STMT4.executeQuery("select distinct depid,depname from clinic_oareport where reportdate between '"+stime+"' and '"+etime+"' order by depid desc");
rsys1=STMT5.executeQuery("select distinct docid,docname,depid from inhos_oareport where reportdate between '"+stime+"' and '"+etime+"' order by docid desc");
rsys2=STMT6.executeQuery("select distinct docid,docname,depid from clinic_oareport where reportdate between '"+stime+"' and '"+etime+"' order by docid desc");
rssy1=STMT7.executeQuery("select depid,itemid,docid,totalmoney from inhos_oareport where reportdate between '"+stime+"' and '"+etime+"' order by depid desc");
rssy2=STMT8.executeQuery("select depid,itemid,docid,totalmoney from clinic_oareport where reportdate between '"+stime+"' and '"+etime+"' order by depid desc");
写的很臭的,达人看了不爽尽管骂:D
inhos_oareport和clinic_oareport是俩个库里的2个表,表结构相同,查询的语句也相同
我想查得stime到etime时间段之间有多少不同的项目,不同的医生,不同的科室,已经这个时间段的收入情况