如何计算多个表中的记录数 [英] How to count number of records from multiple table
本文介绍了如何计算多个表中的记录数的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我有一个查询
Hi i have a query
SELECT tblMaster.Code AS IDRNo,RG.Regno AS RegistrationNo,AD.AdmissionNo,RG.PatientName,BED.BedNo, Dept.Description AS Department, Type =CASE WHEN tblMaster.IDRTypeID=1 THEN 'Medicines' ELSE 'Disposible' END, tblMaster.InsertedOn AS DateTime,tblEmployee_1.EmployeeName AS ApprovedBy, tblMaster.ApprovedDatetime FROM DeptInv.dbo.tblIDRMaster AS tblMaster INNER JOIN PRS.dbo.tblRegistration AS RG ON tblMaster.RegNo = RG.Regno INNER JOIN PRS.dbo.tblAdmission AS AD ON tblMaster.AdmissionNo = AD.AdmissionNo INNER JOIN TKC.dbo.tblDepartment Dept ON tblMaster.DepartmentID=Dept.DepartmentID LEFT OUTER JOIN TKC.dbo.tblEmployee ON tblMaster.InsertedBy = TKC.dbo.tblEmployee.EmployeeID INNER JOIN PRS.dbo.tblBedMaster BED ON AD.BedMasterID=BED.BedMasterID LEFT OUTER JOIN PRS.dbo.tblDischargeStatus ON AD.DischargeStatusID = PRS.dbo.tblDischargeStatus.DischargeStatusID LEFT OUTER JOIN TKC.dbo.tblEmployee AS tblEmployee_1 ON tblMaster.Aprovedby = tblEmployee_1.EmployeeID where tblMaster.Deleted = 0 and IsApproved = 1 AND AD.DischargeStatusID = 2 AND tblMaster.StatusID IN (8,9)
该查询从多个表中获取数据.
现在我想通过使用COUNT函数来计数记录的数量,任何人都可以帮助我,
this query take data from multiple tables.
now i want to count the number of records by using COUNT function, any one help me,
推荐答案
将其存储在临时表中并编写简单的select查询或使用CTE (mssql 2005或更高版本)
http://www.4guysfromrolla.com/webtech/071906-1.shtml [ ^ ]
Store this in a temp table and write simple select query or use CTE (mssql 2005 or above)
http://www.4guysfromrolla.com/webtech/071906-1.shtml[^]
这篇关于如何计算多个表中的记录数的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文