Inner Join / Outer Join and Equi Join

[bashish]

What is exact difference between Inner Join, Outer Join and Equi Join?

[Krzemo]

Equi Join:
it is any join where the "=" symbol is the joining condition.

Inner Join:
An inner join is a join that selects only those records from both database tables that have matching values. Records with values in the joined field that do not appear in both of the database tables will be excluded from the query. One or more fields can serve as the join fields.


Outer join:

An outer join selects all of the records from one database table and only those records in the second table that have matching values in the joined field. In a left outer join, the selected records will include all of the records in the first database table. In a right outer join, the selected records will include all records of the second database table. One or more fields can serve as the join fields.


Best regards,
Krzemo.

[srikanthvja]

hi,

good ans.

i need querys for pactice.
if any body have that list, pls send doc or online link

thanQ