General Note:

Here we have pulled in the data from a sample database. You can download it from the following link and use it for practicing Click Here For Sample Database

Join is the most widely used keyword in SQL. Join is used to retrieve data from more than one table. There are many join functions. They are

CROSS JOIN

NATURAL JOIN

INNER JOIN

OUTER JOIN

Join operator:

join-operator  

Join constraint:

join-constraint