I want to count the result based from the select query, but this query doesn't work. A little help is appreciated.
SELECT Count(*) AS Total FROM
(
SELECT tblPoolReference.EntryDocID
FROM tblPoolReference
INNER JOIN
(
SELECT Distinct Correspondence_ID, Reference_No FROM tblPoolCorrespondence...