inner join sql, database systems

What is inner join?

Inner join shows results from both tables where there is any match between columns in both tables.

RegistrationNo Marks
T4Tutorials1 77
T4Tutorials2 32
T4Tutorials3 88

Table: Exams

Inner join shows results from both tables where there is any match between columns in both tables.

RegistrationNo Fee
T4Tutorials1 1000
T4Tutorials2 2000
T4Tutorials3 3000

Table: Accounts

Now, we have two different tables. If we want to show the record of both tables in one single table then we can use inner join to join both two tables.

Query:

SELECT Exams.RegistrationNo, Exams.Marks, Accounts.Fee FROM Exams INNER JOIN Accounts ON Exams.RegistrationNo =  Accounts.RegistrationNo

RegistrationNo Marks Fee
T4Tutorials1 77 1000
T4Tutorials2 32 2000
T4Tutorials3 88 3000

Table: Table generated after INNER Join

 

Test Your Understandings

1.Inner join shows all rows from all tables ? YES / NO

Answer - Click Here:
No, its show only matching rows