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]

Hi Durga Prasad,

Inner Joins:

++ The typical join operation, which uses some comparison operator like = or <>

++ These include equi-joins and natural joins

++ Inner joins use a comparison operator to match rows from two tables based on the values in common columns from each table.

++ For example, retrieving all rows where the student identification number is the same in both the students and courses tables.

++ Inner joins return rows only when there is at least one row from both tables that matches the join condition.

++ Inner joins eliminate the rows that do not match with a row from the other table

Outer Joins:

++ Outer joins can be a left, a right, or full outer join

++ Outer joins, however, 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

I think it will help you.

If satisfied rewards me..

Kind Regards

Yogesh Gupta