Форумы HiProg.com - MS ACCESS, VBA, VB

ник: Gыwи
примерно так:
SELECT ta.aid, ta.a1-derivedtbl.sumb1 AS itog
FROM ta INNER JOIN [SELECT tb.aid, Sum(tb.b1) AS sumb1
FROM tb
GROUP BY tb.aid]. AS derivedtbl ON ta.aid = derivedtbl.aid;