How to Combine Outer And Inner join In SQL

In this article I am going to explain about how to combine outer and inner join In SQL.
  • 1495

Introduction

Here I am going to explain about how to combine outer and inner join In SQL. There are many situation when we need to retrieve data from more than two table. We can do this with the help of join operator. We can use inner join or outer join. Here we are using both inner and outer join to retrieve data from more than two table.

There are three types of Outer Join

  • Left Outer Join
  • Right Outer Join
  • Full Outer Join

A Statement that create mcninvoices table

inv.jpg

Statements that insert data in mcninvoices table

inv (2).jpg

A Statement that is used to fetch data from mcninvoices table

inv111.jpg

A Statement that create vendors table

ven.jpg

Statements that insert data in vendors table

ven (1).jpg

A Statement that is used to fetch data from vendors table

ven (2).jpg

A Statement that is used to fetch data from mcnemp table

mcnemp.jpg

A Statement that retrieve data from more than two table using both outer and inner join

Clipboard08.jpg


© 2013 dotNetheaven. All rights reserved.