DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: can left join be nested within left join?

  1. #1
    Join Date
    Aug 2001
    Posts
    14
    I have a left join between a table & a query but require the query to have another left join from another table. Is it therefore possible to nest a left join within another left join?
    thanks!

    arage

  2. #2
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,135
    Yes, you can have more than 1 left outer join in SQL Server.

    Example:
    select *
    from tablea left outer join tableb on tablea.col = tableb.col
    left outer join tablec on tablea.col = tablec.col

  3. #3
    Join Date
    Aug 2001
    Posts
    14
    would access97 support such a thing? b/c that's what i'm using.
    thanks!

    arage

Posting Permissions

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


Click Here to Expand Forum to Full Width