Developing.ru

SELECT
CLng([OSTATOK]![SH]) AS [Код группы],
OSTATOK.VID, OSTATOK.NAIM2,
Max(OSTATOK.DATA_PRIH) AS Max_DATA_PRIH, Max(PRODAGA.DATA_DOC) AS Max_DATA_DOC,
Sum(OSTATOK.OST) AS Sum_OST,
Sum(PRODAGA.KOL) AS Sum_KOL
FROM OSTATOK LEFT JOIN PRODAGA ON OSTATOK.NAIM2 = PRODAGA.NAIM2
GROUP BY CLng([OSTATOK]![SH]), OSTATOK.VID, OSTATOK.NAIM2;