SQL Joins

What is SQL joins

A SQL joins are operations that combine rows from two or more tables based on a related column.

Types of SQL joins

1.Inner join - joins only rows that match in both tables.

2.Left join - All rows from the left matches from the right

3.Right join - All rows from the right matches from the left

4.Self join - A table joined to itself

Conclusion

Joins are one of the most powerful features of SQL in that they allow the data stored in separate tables to be combined into meaningful and useful reports for analysis and decision making.