By Team Escalera
on 26 Dec 2017 11:10 AM
  • Joins
0 comments

A JOIN clause is used to combine rows from two or more tables, based on a related column between them.

Types Of Join -

  • INNER JOIN: Returns records that have matching values in both tables
  • LEFT OUTER JOIN: Return all records from the left table, and the matched records from the right table
  • RIGHT OUTER JOIN: Return all records from the right table, and the matched records from the left table
  • FULL OUTER JOIN: Return all records when there is a match in either left or right table

Comments (0)

Leave A Comment