<

SQL OUTER JOIN

In the SQL outer JOIN all the content of the both tables are integrated together either they are matched or not.


Outer join is two types:

  • Left outer join (also known as left join):: this join returns all the rows from left table combine with the matching rows of the right table. If you get no matching in the right table it returns NULL values.

  • Right outer join (also known as right join): this join returns all the rows from right table are combined with the matching rows of left table .If you get no column matching in the left table .it returns null value.
















    • © copyright 2017-2022 Completedone pvt ltd.