Results 1 to 3 of 3
  1. #1
    4 Star Lounger
    Join Date
    Jun 2001
    Posts
    531
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Multiple left joins (97)

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

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Multiple left joins (97)

    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;
    Francois

  3. #3
    4 Star Lounger
    Join Date
    Jun 2001
    Posts
    531
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Multiple left joins (97)

    What if I use that? I

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •