SELECT Inv.Location, Count(OnHand.PK);
>   FROM Inv;
>   LEFT OUTER JOIN OnHand ON Inv.PK = OnHand.FK;
>   GROUP BY Inv.Location