SQL JOINS are used to retrieve data from multiple tables. A SQL JOIN is performed whenever two or more tables are joined in a SQL statement.
There are 4 different types of SQL joins:
- SQL INNER JOIN
- SQL LEFT OUTER JOIN
- SQL RIGHT OUTER JOIN
- SQL FULL OUTER JOIN
Consider there are two tables as following
a) Student Table b) Advisor Table
Now let us join these tables using INNER JOIN .
SQL> SELECT * FROM Student S
INNER JOIN Advisor A
The result would be as follows.