SQL INNNER JOIN - Learn2Done

The INNER JOIN keyword returns matching values from both tables.

Syntax:

SELECT column_name(s) FROM left_table
INNER JOIN right_table
ON left_table.column_name = right_table.column_name;

DEMO TABLES

STUDENTS TABLE

Data

CLG TABLE

Data

Example: To perform inner join on both the above tables

SELECT Roll_No, Name FROM students
INNER JOIN clg
ON students.Roll_No = clg.Roll_No;

The resultant table will be as shown below:

Data