SELECT A.OwedTo, A.plus - B.minus AS Beer
FROM
(
   SELECT OwedTo, SUM(Beer) AS plus
    FROM myBeers
    GROUP BY OwedTo
) A
INNER JOIN
(
    SELECT OwedBy,...