What is the difference between Natural Join and Inner Join?
The most common type of join is: SQL INNER JOIN (simple join). An SQL
INNER JOIN return all rows from multiple tables where the join condition
is met.
This what W3Schools says about Inner Join. I was reading database
management by Korth and one chapter in it was on relational algebra. In
that, there was a Natural Join which, in my limited understanding, is the
same as Inner Join.
Can someone please tell me if there is a difference between the two or
they are different names of referring to the same thing.
No comments:
Post a Comment