Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / khaleek
There are only three type of joins
1) Equi Join
2) Non Equi Join
3) Cartesian Product or Cross Join.
Further Equi Join and Non Equi join can be divided into
following categories.
1) Inner Join
2) Outer Join
3) Self Join
Again Outer can be divide into following categories.
1) Left Outer Join
2) Right Outer Join
3) Full Outer Join
For detail please see at
<a
href="http://interview-preparation-for-you.blogspot.com/2010/11/difference-between-inner-joinouter-join.html">http://interview-preparation-for-you.blogspot.com/2010/11/difference-between-inner-joinouter-join.html</a>
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
What type of database is sql?
what does it mean to have quoted_identifier on? : Sql dba
What is offset and limit in sql?
How does sql developer connect to oracle database?
What is auto increment feature in sql?
What is coalesce in sql?
What is dcl in sql?
What does dml mean?
what is error ora-03113: end-of-file on communication channel?
Why procedure is used in sql?
what is the difference between delete and truncate statement in sql? : Sql dba
how to calculate expressions with sql statements? : Sql dba
What is natural join in sql?
What is right join sql?
1) Synonyms 2) Co-related Subquery 3) Different Jobs in Plsql 4) Explain Plan 5) Wrap 6) Query Optimization Technique 7) Bulk Collect 8) Types of index 9) IF primary key is created then the index created ? 10) Foreign Key 11) Exception Handling 12) Difference Between Delete and Trunc 13) Procedure Overloading 14) Grant Revoke 15) Procedure Argument types. 16) Functions. 17) Joins
