SELECT G.NameGroup, G.AvrPrice, G.IDGroup, R1.IDRequest, R1.DateRequest, R1.Amount AS Amount1,
    R2.Amount AS Amount2, R3.Amount AS Amount3, R4.Amount AS Amount4, R5.Amount AS Amount5,
    (Amount1+Amount2+Amount3+Amount4+Amount5) AS TotalAmount
FROM ((((([$GroupsFood] AS G 
LEFT JOIN Requests AS R1 ON ((R1.IDGroup=G.IDGroup) AND (R1.DateRequest=# 01 / 01 / 2001 #) AND (R1.IDDinner= 0 )))
LEFT JOIN Requests AS R2 ON ((R2.IDGroup=G.IDGroup) AND (R2.DateRequest=# 01 / 01 / 2001 #) AND (R2.IDDinner= 1 )))
LEFT JOIN Requests AS R3 ON ((R3.IDGroup=G.IDGroup) AND (R3.DateRequest=# 01 / 01 / 2001 #) AND (R3.IDDinner= 2 )))
LEFT JOIN Requests AS R4 ON ((R4.IDGroup=G.IDGroup) AND (R4.DateRequest=# 01 / 01 / 2001 #) AND (R4.IDDinner= 3 )))
LEFT JOIN Requests AS R5 ON ((R5.IDGroup=G.IDGroup) AND (R5.DateRequest=# 01 / 01 / 2001 #) AND (R5.IDDinner= 4 )))