Hello,
I have the following query where a course has a course licensing profile where there are users utilizing licenses.
When there is a course record and a course licensing record, but no user licenses used; the query i have reports a usercount of 1. How can i get it to display a count of zero?
SELECT tblCourseLicensing.CourseL
icensingID
, tblCourse.Name, COUNT(*) AS UserCount
FROM tblCourseLicensing INNER JOIN
tblCourse ON tblCourseLicensing.CourseI
D = tblCourse.CourseID LEFT OUTER JOIN
tblCourseLicensingUser ON tblCourseLicensing.CourseL
icensingID
= tblCourseLicensingUser.Cou
rseLicensi
ngID
GROUP BY tblCourseLicensing.CourseL
icensingID
, tblCourse.Name
HAVING (tblCourseLicensing.Course
LicensingI
D = 1)
Start Free Trial