SQL Join statement is used to combine data or rows from two or more tables based on a common field between them. Different types of Joins are as follows:

• INNER JOIN

• LEFT JOIN

• RIGHT JOIN

• FULL JOIN

• NATURAL JOIN

Consider the two tables below as follows:

Student

StudentCourse

The simplest Join is INNER JOIN.

A. INNER JOIN

The INNER JOIN keyword selects all rows from both the tables as long as the condition is satisfied. This keyword will create the result-set by combining all rows from both the tables where the condition satisfies i.e value of the common fie...