>Try:
>
SELECT Inv.Location, Count(OnHand.PK);
> FROM Inv;
> LEFT OUTER JOIN OnHand ON Inv.PK = OnHand.FK;
> GROUP BY Inv.Location
HTH
>
Actually, that did help, I didn't realize how grouping worked before...I used SUM() instead of COUNT() to get the total on hand...Thanks Sylvain!!
But now, if I search on a part in location 01 and it's there's no stock in location 01, in which case there wouldn't be an entry in the onhand table, how do I get it to select that part number and instead say that onhand=0?