Thread: What is the difference between self join and outer join?

fitjfdgfjgifjgjijfngijgjdgjdigdhgudhgshfhfsfdshfudsruhdrusdurudr

Hi Swapna this is the answer for your question i think

Outer joins return all rows from at least one of the tables or views mentioned in the FROM clause, as long as those rows meet any WHERE or HAVING search conditions. All rows are retrieved from the left table referenced with a left outer join, and all rows from the right table referenced in a right outer join. All rows from both tables are returned in a full outer join

A table can be joined to itself in a self-join.

You can use outer join to get the leftovers where as self join is used to compare a table with itself. In self join we consider the same table as two tables bearing the alies names

SELF JOIN --is join of the same table to itself.

OUTER JOIN-- is join to another table to select non matching records also. it can be left outer or right outer join.

Hi,

The Self Join is the concept joining the same table to it self, in that we use the alias concept to differ the tables.

In the Outer join we can use 3 types left, right or full, we can use the same tables for the outer join also but there won't be any meaning for that.