Explaining SQL Joins and types of joins.
So when we are dealing with SQL we join two tables with primary and foreign key relationship, which combine rows from respective table.Joins are very integral part of SQL.
The four types of join we use are:
1. Inner Join
2. Left Join
3. Right Join
4. Full Join