Multiple left joins (97)

[arage]

I can design a query where 5 left joins from one query to another will work but won

[Francois]

What if you use :
SELECT Query5.promotionType, Query5.DirectorCode, Query5.Code, Query5.Year, Query5.Month, Query5.ManagerName
FROM Query5 LEFT JOIN NewQuery ON (Query5.Month = NewQuery.tempMonth) AND (Query5.promotionType=NewQuery.PromotionType) AND (Query5.DirectorCode=NewQuery.RegionalDirectorCode ) AND (Query5.Code=NewQuery.Code) AND (Query5.Year=NewQuery.tempYear)
GROUP BY Query5.promotionType, Query5.DirectorCode, Query5.Code, Query5.Year, Query5.Month, Query5.ManagerName;

[arage]

What if I use that? I