Results 1 to 5 of 5

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

  1. #1
    Junior Member
    Join Date
    Jun 2008
    Answers
    1

    What is the difference between self join and outer join?

    fitjfdgfjgifjgjijfngijgjdgjdigdhgudhgshfhfsfdshfudsruhdrusdurudr


  2. #2
    Junior Member
    Join Date
    Jun 2008
    Answers
    5

    Arrow 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.


  3. #3
    Junior Member
    Join Date
    Mar 2008
    Answers
    3

    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


  4. #4
    Moderator
    Join Date
    Jun 2007
    Answers
    2,074

    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.


  5. #5
    Contributing Member
    Join Date
    Apr 2008
    Answers
    31

    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
  •  
About us
Applying for a job can be a stressful and frustrating experience, especially for someone who has never done it before. Considering that you are competing for the position with a at least a dozen other applicants, it is imperative that you thoroughly prepare for the job interview, in order to stand a good chance of getting hired. That's where GeekInterview can help.
Interact