Differences between Inner join and outer join

[Former Member]

Please any one tell what are the differences between Inner join and Outer join plz tell me

points will be rewarded

[Former Member]

Hai Prasad,

The data that can be selected with a view depends primarily on whether the view implements an inner join or an outer join.

With an inner join, you only get the records of the cross-product for which there is an entry in all tables used in the view.

With an outer join, records are also selected for which there is no entry in some of the tables used in the view.

The set of hits determined by an inner join can therefore be a subset of the hits determined with an outer join.

Regards.

Eshwar.