Explain different types of JOINS in SQL ?
The following are the JOINS in SQL
. INNER JOIN
. OUTER JOIN
>> LEFT OUTER JOIN
>> RIGHT OUTER JOIN
>> FULL OUTER JOIN
Inner Join:
This will give results by selecting matching rows between two tables.
Left Outer Join:
This will give results by selecting matching rows from both the tables plus all the rows from left table.
Right Outer Join:
This will give results by selecting matching rows from both the tables plus all the rows from right table.
Full Outer Join:
This will give all the rows from both the tables.