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 tables but only one copy of each common column.
Consider the two tables given below:
Consider the given query
SELECT * FROM Student S NATURAL JOIN Marks M;
2. Cross Join :
Cross Join will produce cross or Cartesian product of two tables if there is no condition specifies. The resulting table will contain all the attributes of both the tables including duplicate or common columns also.
Consider the above two tables and the query is given below:
SELECT * FROM Student S CROSS JOIN Marks M;
Difference between Natural JOIN and CROSS JOIN in SQL
|SR.NO.||NATURAL JOIN||CROSS JOIN|
|1.||Natural Join joins two tables based on same attribute name and datatypes.||Cross Join will produce cross or cartesian product of two tables .|
|2.||In Natural Join, The resulting table will contain all the attributes of both the tables but keep only one copy of each common column||In Cross 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 column||In Cross Join, If there is no condition specifies then it returns all possible pairing of rows from both the tables whether they are matched or unmatched|
SELECT * FROM table1 NATURAL JOIN table2;
SELECT * FROM table1 CROSS JOIN table2;
Don’t stop now and take your learning to the next level. Learn all the important concepts of Data Structures and Algorithms with the help of the most trusted course: DSA Self Paced. Become industry ready at a student-friendly price.
- Difference between Natural join and Inner Join in SQL
- Difference between Inner Join and Outer Join in SQL
- SQL | Join (Cartesian Join & Self Join)
- Inner Join vs Outer Join
- Difference between JOIN and UNION in SQL
- Difference between Lossless and Lossy Join Decomposition
- Difference between Left, Right and Full Outer Join
- SQL Join vs Subquery
- Join statement in JCL
- Join algorithms in Database
- SQL | Join (Inner, Left, Right and Full Joins)
- Join operation Vs Nested query in DBMS
- Lossless Join and Dependency Preserving Decomposition
- What is PJNF(Project-Join Normal Form)?
- Differences between wait() and join() methods in Java
- Difference between Cross-Assembler and Compiler
- Difference between Native compiler and Cross compiler
- Cross Product Operation in DFA
- Mathematics | Sum of squares of even and odd natural numbers
- Difference between IBM DB2 and MS SQL
If you like GeeksforGeeks and would like to contribute, you can also write an article using contribute.geeksforgeeks.org or mail your article to email@example.com. See your article appearing on the GeeksforGeeks main page and help other Geeks.
Please Improve this article if you find anything incorrect by clicking on the "Improve Article" button below.