Viewing 2 posts - 1 through 2 (of 2 total)
So we can try using INNER JOIN instead of LEFT JOIN for the NonAdmitReason table.
December 9, 2009 at 6:30 pm
#1090300
I think the problem is of the WHERE clause which rules out all the cases when refTrkVisit not exist.
Try this:
SELECT
COUNT(refTrkVisit.visitID) AS count,
refTrkNonAdmitReason.description,
...
December 9, 2009 at 2:45 am
#1089695