TOP CATEGORIES

×

What is the difference between self join and inner join?

K

Komika

inner join self join

Major Difference Between Self Join & Inner Join

Self Join is used to Join a table to itself which returns the rows from the table that satisfy the given join condition; whereas Inner Join is used to Join two or more tables that return the rows that satisfy the given join condition.

0 votes

Your Answer