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 |
Which command is used to call a stored procedure?
What is view? Can we update view
Mention what is the function that is used to transfer a pl/sql table log to a database table?
How do I run sql profiler?
What is the difference between left join and right join?
Why partition by is used in sql?
List the different type of joins?
What is time based sql injection?
Can we use views in stored procedure?
what are all the common sql function? : Sql dba
Can ddl statements be used in pl/sql?
Can you inner join the same table?
Oracle (3253)
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)