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 are the differences between get and post methods in form submitting. Give the case where we can use get and we can use post methods? : Sql dba
What does plv msg allows you to do?
What is optimistic concurrency control? : Transact sql
Why do we go for stored procedures?
What is rename in sql?
What are the commands used in sql?
What is sql analyzer?
What are different categories of sql commands?
What are the types of join in sql?
How do I run a pl sql program?
Define SQL and state the differences between SQL and other conventional programming Languages?
Is sql difficult?
Do triggers have restrictions on the usage of large datatypes, such as long and long raw?
What is sql profiler in oracle?
How long does it take to learn pl sql?