(SELECT ComplaintDetails.BranchName,ComplaintDetails.FranchiseeName,COUNT(*) AS 'TD' FROM ComplaintDetails
WHERE
TDate BETWEEN @FROMDATE AND @TODATE
GROUP BY ComplaintDetails.BranchName,ComplaintDetails.FranchiseeName) AS B LEFT OUTER JOIN
(SELECT BranchName,FranchiseeName,COUNT(*) AS 'TC' FROM SurveyDetails
WHERE SurveyDate BETWEEN @FROMDATE AND @TODATE
GROUP BY BranchName,FranchiseeName)As A
ON
B.BranchName = A.BranchName
AND
B.FranchiseeName = A.FranchiseeName
ORDER BY
B.BranchName
No comments:
Post a Comment