There are Four Joins used in SQL DatabaseWhen joining two tables in SQL Join, then Make sure that the column name of both tables is the same otherwise It is not possible to join two tables with SQL Join; Types of SQL Join with Small descriptions:
- Full Join - Retrieve all the records from two are more tables
- Left SQL Joining OR Left Outer Join - Retrieve all the records from the left table BUT on common records from the right table & The outer join ignores the common records from both tables.
- Right SQL Joining OR Right Outer Join - Retrieve all the records from the right table BUT on common records from the left table.
- Inner Join - Retrieve all the records, which one common both the table.