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
Why is there a need for sqlcode and sqlerrm variables?
What is orm in sql?
How do I quit sql?
Is join and inner join the same?
How do I truncate a word?
Is it possible to update views?
What is input buffer in sql*plus?
What is the maximum number of columns in sql table?
What is difference between hql and sql?
Are dml statements autocommit?
Can we update views in sql?
What is integrity in sql?
Can we call dml statement in function?
What is nosql example?
Why do we create stored procedures & functions in pl/sql and how are they different?
