SQL 条件限制问题？

[xqfxgrh]

SELECT TOP 5 sUserName,

(SELECT sum(b.iPageCount) FROM fastManOwner.FMPrt_PrintApply b
INNER JOIN fastManOwner.FMPrt_Print c ON b.iPrintApplyID=c.iPrintApplyID AND a.iUserCode=b.iCreateUC AND b.bDelete<>1 AND b.iFlowState=4
AND DATEDIFF(day,c.tPrintDate,getdate())=0) AS TodaySumiPageCount,

(SELECT sum(iPageCount) FROM fastManOwner.FMPrt_PrintApply b
INNER JOIN fastManOwner.FMPrt_Print c ON b.iPrintApplyID=c.iPrintApplyID AND a.iUserCode=b.iCreateUC AND b.bDelete<>1 AND b.iFlowState=4)
AS SumiPageCount

FROM fastManOwner.FSys_User a

WHERE bDelete<>1

ORDER BY TodaySumiPageCount DESC,SumiPageCount DESC
如何为TodaySumiPageCount ,SumiPageCount 加入条件？

[chuifengde]

select * from (你上面的语句) aa where 条件