Select PR_PT.cTmpCode,max(PR_PT.cTmpName) as cTmpName,max(PR_PT.cDescription) as cDescription,case when exists(select * from PR_StuPrintRecord S where S.cTmpCode = PR_PT.cTmpCode and S.cStuCode='20122015') then (select count(*) from PR_StuPrintRecord SPR where SPR.cTmpCode= PR_PT.cTmpCode and SPR.cStuCode='20122015' ) else 0 end as iPrintTimes,max(iPrintLimitTimes) as iLimitTimes From PR_PrintTemplate PR_PT group by PR_PT.cTmpCode order by PR_PT.cTmpCode 根据学号对不同的打印模块进行打印次数统计,如果该学号的某打印模块尚未打印显示为0,否则显示
相应的打印次数。