Oops! It appears that you have disabled your Javascript. In order for you to see this page as it is meant to appear, we ask that you please re-enable your Javascript!

inner join in sql and DBMS

Last modified on January 3rd, 2019 at 2:44 pm

inner join in SQL and DBMS

Today, in this fresh and new article, we will cover the following topics;

  1. What is inner join?
  2. Example of inner join
  3. Query of an inner join

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

RegistrationNoMarks
T4Tutorials177
T4Tutorials232
T4Tutorials388

Table: Exams

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

RegistrationNoFee
T4Tutorials11000
T4Tutorials22000
T4Tutorials33000

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 of an inner join

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

RegistrationNoMarksFee
T4Tutorials1771000
T4Tutorials2322000
T4Tutorials3883000

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

Topic Covered

inner join in sql and DBMS

Prof. Fazal Rehman Shamil
Researcher, Publisher of International Journal Of Software Technology & Science ISSN: 2616-5325
Instructor, SEO Expert, Web Programmer and poet.
Feel free to contact.