Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2003
    Location
    US
    Posts
    314

    Arrow Unanswered: Outer Join and Inner Join

    Hi
    I have been intrigued a bit with the terminology of outer and inner join.
    I have been using outer joins as a.orderid=b.orderid(+) which means, that even if table b doesnt have the columns corresponding to orderids in a, it would still return the request row.

    I dont know what is the inner join ?? Why and how is it used, and what is the case where inner join comes in handy.
    Thanx and Regards
    Aruneesh

  2. #2
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1

    Re: Outer Join and Inner Join

    Originally posted by aruneeshsalhotr
    Hi
    I have been intrigued a bit with the terminology of outer and inner join.
    I have been using outer joins as a.orderid=b.orderid(+) which means, that even if table b doesnt have the columns corresponding to orderids in a, it would still return the request row.

    I dont know what is the inner join ?? Why and how is it used, and what is the case where inner join comes in handy.
    Thanx and Regards
    Aruneesh
    Inner join is just a regular join, without the (+).

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •