I have a requirement to count 3 different amounts of content in a selected field.
My logic has written a query as follows, but this doesn't work as expected. Please can anyone shed some light?
COUNT(DISTINCT rU.ID_User) AS Registered,
COUNT(DISTINCT aU.ID_User) AS Accepted,
COUNT(DISTINCT pU.ID_User) AS Partial
ATL_V2_Affiliates AS A
Left Join ATL_Users AS rU ON rU.ID_Affiliate AND rU.RegStatus='Registered'
Left Join ATL_Users AS aU ON aU.ID_Affiliate AND aU.RegStatus='Accepted'
Left Join ATL_Users AS pU ON pU.ID_Affiliate AND pU.RegStatus='Partial'