Skip to content
Related Articles

Related Articles

Improve Article
Save Article
Like Article

Difference between Natural join and Inner Join in SQL

  • Difficulty Level : Basic
  • Last Updated : 31 Aug, 2021

Prerequisite – Join (Inner, Left, Right and Full Joins) 
1. Natural Join : 
Natural Join joins two tables based on same attribute name and datatypes. The resulting table will contain all the attributes of both the table but keep only one copy of each common column. 

Example: 
Consider the two tables given below: 

Attention reader! Don’t stop learning now. Learn SQL for interviews using SQL Course  by GeeksforGeeks.

Student Table 
 



Marks Table 
 

Consider the given query 

SELECT * 
FROM Student NATURAL JOIN Marks;

Output: 

 

2. Inner Join : 
Inner Join joins two table on the basis of the column which is explicitly specified in the ON clause. The resulting table will contain all the attributes from both the tables including common column also. 

Example: 
Consider the above two tables and the query is given below: 

SELECT * 
FROM student S INNER JOIN Marks M ON S.Roll_No = M.Roll_No; 

Output : 

 

Difference between Natural JOIN and INNER JOIN in SQL : 

SR.NO.NATURAL JOININNER JOIN
1.Natural Join joins two tables based on same attribute name and datatypes.Inner Join joins two table on the basis of the column which is explicitly specified in the ON clause.
2.In Natural Join, The resulting table will contain all the attributes of both the tables but keep only one copy of each common columnIn Inner Join, The resulting table will contain all the attribute of both the tables including duplicate columns also
3.In Natural Join, If there is no condition specifies then it returns the rows based on the common columnIn Inner Join, only those records will return which exists in both the tables
4.SYNTAX: 
SELECT * 
FROM table1 NATURAL JOIN table2; 
 
SYNTAX: 
SELECT * 
FROM table1 INNER JOIN table2 ON table1.Column_Name = table2.Column_Name; 
 

The Natural Joins are not supported in the SQL Server Management Studio also knowns as Microsoft SQL Server.

My Personal Notes arrow_drop_up
Recommended Articles
Page :

Start Your Coding Journey Now!