Problemas al Usar INNER JOIN

[fernandoarbe]

La forma de como lo resolvería sin complicados GROUP BY

Código SQL:

SELECT DISTINCT
    Region.RegionDescription
    ,Terriorios_xRegion.nTerritorios
    ,Empleados_xRegion.nEmpleados
FROM
    Region
    INNER JOIN (
        SELECT
            Territories.RegionID
            ,COUNT(Territories.TerritoryID) AS nTerritorios
        FROM
            Territories
        GROUP BY
            Territories.RegionID
        ) Terriorios_xRegion
        ON Terriorios_xRegion.RegionID = Region.RegionID
    INNER JOIN (
        SELECT 
            Territories.RegionID
            ,COUNT(EmpleyeeTerritories.EmployeeID) AS nEmpleados
        FROM
            Territories
            INNER JOIN EmpleyeeTerritories
                ON Territories.TerritoryID = EmpleyeeTerritories.TerritoryID
        GROUP BY
            Territories.RegionID
        ) Empleados_xRegion
        ON Empleados_xRegion.RegionID = Region
ORDER BY
    Region.RegionDescription