DB2 left outer join vs left join

Posted on 2009-02-13
Last Modified: 2012-06-27
In DB2 , does left outer join work the same as left join?  Thanks.
Question by:ewang1205
    LVL 18

    Accepted Solution


    Yes.  "left join" is synonymous with "left outer join".

    LVL 57

    Assisted Solution

    by:Raja Jegan R
    Joins fall into two types:
    1. Inner Join.
    2. Outer Join. (Left / Right / Full)

    LEFT OUTER JOIN is the keyword which we will be using in the query. In general practice, it is also called as Outer Join.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Join & Write a Comment

    November 2009 Recently, a question came up in the DB2 forum regarding the date format in DB2 UDB for AS/400.  Apparently in UDB LUW (Linux/Unix/Windows), the date format is a system-wide setting, and is not controlled at the session level.  I'm n…
    Recursive SQL in UDB/LUW (you can use 'recursive' and 'SQL' in the same sentence) A growing number of database queries lend themselves to recursive solutions.  It's not always easy to spot when recursion is called for, especially for people una…
    how to add IIS SMTP to handle application/Scanner relays into office 365.
    In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor ( If you're interested in additional methods for monitoring bandwidt…

    746 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    15 Experts available now in Live!

    Get 1:1 Help Now