Menu

SQL INNER JOIN with Example


In SQL the INNER JOIN is used to selects records that have matching values in both tables.

SQL INNER JOIN Syntax

SELECT column_name(s)
FROM table1
INNER JOIN table2 ON table1.column_name = table2.column_name;

inner join

SQL INNER JOIN Example

Assume that we have two table

students_data table

RollNo Name Address ContactNo
1 Divya Mumbai 9437911966
2 Hritika Pune 9887454545
3 Amit Delhi 7766888888

students_mark table

RollNo Mark Grade
1 95 O
2 85 A
3 65 B

Example

SELECT students_data.RollNo, students_data.Name, students_data.Address, students_mark.Marks, students_mark.Grade
FROM students_data
INNER JOIN students_mark ON students_data.RollNo = students_mark.RollNo;
RollNo Name Address Mark Grade
1 Divya Mumai 95 O
2 Hritika Pune 85 A
3 Amit Delhi 65 B







Connection failed: SQLSTATE[28000] [1045] Access denied for user 'studentdb'@'localhost' (using password: YES)

Subscribe