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 is graph sql?
What is the most common sql injection tool?
Can you join views in sql?
What if we write return in procedure?
Can we use insert statement in function?
What is a common use of group by in sql?
Explain the uses of control file.
Explain two easy sql optimizations.
what are the advantages a stored procedure? : Sql dba
What are the different tcl commands in sql?
Is sql database free?
What is exit statement?
What port does sql server use?
What is a pl/sql block?
What type of database is cloud sql?