Multiple left joins (97)

Topic

New Reply

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

Reply | Quote

Replies

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;

Reply | Quote

What if I use that? I

Reply | Quote