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 company owns postgresql?
What are the different types of sql commands?
how can we transpose a table using sql (changing rows to column or vice-versa) ? : Sql dba
What is the difference between microsoft access and sql?
Are dml statements autocommit?
Can I join the same table twice?
Why are sql stored procedures used?
What does sign mean sql?
Why is stored procedure faster than query?
Does pdo prevent sql injection?
how do you tune the slow running queries in oracle db , explain the methodology
What is the use of double ampersand (&&) in sql queries? Give an example
What is clustered index sql?
What are different types of tables in sql?
how to convert dates to character strings? : Sql dba
