27,579
社区成员
发帖
与我相关
我的任务
分享
select count(distinct Uniteng_head.projectid)项目,count( Uniteng_head.uniteng_id)单位工程,
count( AJ_Record.aj_id)案卷,count(WJ_Record.wj_id)文件,sum(WJ_Record.sl)图纸
from Uniteng_head inner join AJ_Record
on AJ_Record.Unitengid=Uniteng_head.UnitEng_id
inner join WJ_Record on WJ_Record.aj_id=AJ_Record.aj_id
这里用到的distinct 是要统计项目数,又不想去项目表里查而用的.但就是这样,查出的结果还是有重复记录.