Difference between INNER JOIN and OUTER JOIN in SQL Server

Was this helpful?

0 votes

I am not sure what the difference is between INNER JOIN and OUTER JOIN. Can someone perhaps give an example with a simple query?

BTW: I am using SQL Server, but ORACLE is fine too.

Jun 16, 2016.

share edit

Harkrishna Nair
{ 50 - 1 - 0 }

add comment

Your Answer

We'll remember your Answer.

Looking for a job?

JP/Morgan Chase

Dallas, Texas

Accenture

New York

Microsoft

Seattle

Startup (stealth)

London, UK

•	Difference between jQuery and Angular
•	What is the difference between a Static Class and Singleton?
•	Server Side Rendering
•	Server Side Rendering in JavaScript?
•	SQL Select only rows with MAX columns value
•	How to pass a parameter to a SQL IN clause with C#, SQL Server
•	Difference between {{ expression }} and ng-bind
•	Difference between {{ expression }} and ng-bind
•	Difference between {{ expression }} and ng-bind
•	Is there a difference between String and string in C#?