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
AruneeshOriginally 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 (+).