Thursday, July 30, 2015

SQL tutorial - Lesson 10 - Full outer join

Full outer join returns all the rows from left table and also returns all the rows from the right table

Syntax: 

  Select "column name" from "table1" full outer join "table2" on table1.coulmn  =table2.column


Note: Please do not use  quotes when trying to type the query I just mentioned so that you can understand better

No comments:

Post a Comment