LEFT JOIN

SQL Joins

SQL joins combine two or more tables based on a common field between them. Here we are describing different types of Joins that are used in SQL below....

LEFT JOIN

In SQL, the Left join is used to fetch all the data from the Left table and common from both tables. If there are no matching records present in the left table then it returns the NULL value....

RIGHT JOIN

In SQL, Right join is used to fetch all the data from the Right table and common from both tables. If there are no matching records present in the right table then it returns the NULL value....

INNER JOIN

It is used to fetch the common data from the tables. It returns only that value when there is a matched column between them....

FULL JOIN

In SQL, FULL JOIN is used to fetch all the records from both tables. If there is no matches in one of the table then its return the NULL value....

Conclusion

In this article, we have basically mentioned the SELECT data from multiples tables and JOINS, and their types.Both the Statement, whether the Select or the Joins, play an important role in the Structured query language (SQL). Select statements are used to fetch the records from multiple tables and with the help of joins statement we can fetch what type of records you have to need. we have discussed all JOINS operations and their syntax with examples. and we also mentioned the three tables and showed the joins operation on them....