- Forum
- Databases
- SQL What is the difference between self join and outer join?
-
Junior Member
What is the difference between self join and outer join?
fitjfdgfjgifjgjijfngijgjdgjdigdhgudhgshfhfsfdshfudsruhdrusdurudr
-
Junior Member
Re: What is the difference between self join and outer join?
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.
-
Junior Member
Re: What is the difference between self join and outer 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
-
Re: What is the difference between self join and outer join?
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.
-
Contributing Member
Re: What is the difference between self join and 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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules