SQL Joins

SQL Join statement is used to combine data or rows from two or more tables based on a common field between them. Different types of Joins are as follows: 

         INNER JOIN

             Returns records that have matching values in both tables

         LEFT JOIN

 

             Returns all records from the left table, and the matched records from the right table

         RIGHT JOIN

 

            Returns all records from the right table, and the matched records from the left table

         

         FULL JOIN

             Returns all records when there is a match in either left or right table