Types of joins ?
Answers were Sorted based on User's Feedback
Answer / 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 |
What is nvarchar max in sql?
What are the different dml commands in sql?
What is an intersect?
Is progress software supports to ( pl/sql )?
Can we create index on primary key?
Can you load data into multiple tables at once? : aql loader
What version is sql?
Is sql harder than python?
what are the differences between require and include, include_once and require_once? : Sql dba
What are different types of sql commands?
What is gpt format?
If we update a complex view, is base table will get update ?
2 Answers Ardee Technologies, HCL,
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)