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
Can a foreign key be null?
what is 'mysqladmin' in mysql? : Sql dba
What is difference between group by and partition by?
Write an sql query to select all records from the table?
What is sharding in sql?
What will you get by the cursor attribute sql%rowcount?
What is percent sign in sql?
What is set serveroutput on?
What are basic techniques of indexing?
what are numeric data types? : Sql dba
What is partition in sql query?
how to check myisam tables for errors? : Sql dba
What is an invalid partition table?
Can you have more than one trigger on a table?
Explain the advantages and disadvantages of stored procedure?
