Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


DB2 left outer join vs left join

Posted on 2009-02-13
Medium Priority
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

Dave Ford earned 1600 total points
ID: 23637919

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

LVL 57

Assisted Solution

by:Raja Jegan R
Raja Jegan R earned 400 total points
ID: 23638949
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

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

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…
Integration Management Part 2
As many of you are aware about Scanpst.exe utility which is owned by Microsoft itself to repair inaccessible or damaged PST files, but the question is do you really think Scanpst.exe is capable to repair all sorts of PST related corruption issues?
Suggested Courses

564 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