Solved

difference between left outer join and inner join

Posted on 2008-10-15
4
725 Views
Last Modified: 2012-05-05
what is the difference between left outer join and inner join>>>>
0
Comment
Question by:harisbscs2003
4 Comments
 
LVL 53

Accepted Solution

by:
Dhaest earned 50 total points
ID: 22720849
A good example and explanation:
http://en.wikipedia.org/wiki/JOIN
0
 
LVL 16

Expert Comment

by:brad2575
ID: 22721001
Inner Join will only return records that are in BOTH tables, if a record is NOT in both it will NOT return them from EITHER table.

Left outer join will return ALL records from the first table in the JOIN statement no matter if it is in the second table or not.  If there is no data in the second table it will return NULL for all the values in the second table.
0

Featured Post

Highfive Gives IT Their Time Back

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Suggested Solutions

Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
Composite queries are used to retrieve the results from joining multiple queries after applying any filters. UNION, INTERSECT, MINUS, and UNION ALL are some of the operators used to get certain desired results.​
In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…
In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're interested in additional methods for monitoring bandwidt…

760 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

21 Experts available now in Live!

Get 1:1 Help Now