SQL: Get count using a JOIN (Grouping before the Join) 2010-01-112020-06-14 Pete Sral Count of records using a sub-query bypassing the limits of the Group By.