SELECT F.IDFood, F.NameFood, U.ShortNameUnit, SUM(I.Kol) AS Kol, B.Price, 
SUM(I.Kol*B.Price) AS Summ, SUM(R.Amount) AS Amount, (Kol*Amount) AS 
TotalKol, (TotalKol*Summ) AS TotalSumm
FROM (((((Menu AS M 
LEFT JOIN KatDishes AS D ON M.IDDish=D.IDDish) 
LEFT JOIN KatIngredients AS I ON I.IDDish=D.IDDish) 
LEFT JOIN KatFoods AS F ON I.IDFood=F.IDFood) 
LEFT JOIN KatUnits AS U ON U.IDUnit=F.IDUnit) 
LEFT JOIN Balance AS B ON B.IDFood=I.IDFood) 
LEFT JOIN Requests AS R ON (R.IDDinner=M.IDDinner) AND (R.DateRequest=M.DateMenu)
WHERE M.DateMenu=# 10 / 02 / 2003 #
GROUP BY F.IDFood, F.NameFood, U.ShortNameUnit, B.Price
ORDER By NameFood