Equi Join: When primary and foreign key relationship exists between the tables that are going to be joined.
Cartesian Join: When tables are joined without giving any join condition.
Inner Join: The resultant set includes all the rows that satisfy the join condition.
Outer Join: The resultant set includes the rows which doesn’t satisfy the join condition. The outer join operator Plus sign (+) will be included in the join condiiton.
Example: SELECT a. column1, a. column2, b.column3….. from a, b where a.column1(+)=b.Column1
Here the rows from table a which doesn’t satisfy the join condition will also be fetched.
07:34:09 am, by 
Comment feed for this post
