What are joins..how many types of joins are there?
- 29 Answers
- 76496 Views
- Amdocs, CSC, TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Basically join's are three type's those are :
1.Cross join
2.Equi join
a.Natural join
b.inner join
c.outer join(Simple join)
i.Left outer join
ii.Right outer join
iii.Full outer join
d.Self join
3.Non-equi join
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / prabhat shukla
Basically there are three types of join
1.Inner join
2.Outer join
3.self join
and there are two types of join based on condition.
1.equi-join(if we use equal operator while joining tables)
2.Non-equi-join( if we use other than equal operator while
joining tables.(this on is rarely used.)
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / sourabh sharma
=>INNER JOIN: Return rows when there is at least one match
in both tables
=>LEFT JOIN: Return all rows from the left table, even if
there are no matches in the right table
=>RIGHT JOIN: Return all rows from the right table, even if
there are no matches in the left table
=>FULL JOIN: Return rows when there is a match in one of the
tables
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / tauqueer
Joins means we can join two or more then two table in
single query.
there are 3 types of join..
1. INNER JOIN.
2. OUTER JOIN.
1.Left outer join.
2.right outer join.
3.full outer join.
3. CROSS JOIN.
| Is This Answer Correct ? | 0 Yes | 1 No |
Answer / m.sivakumar
joins is a that combines the rows from two or more tables
joins are 5 types
1.cross join
2.equi join or inner join
3.outer join
4.self join
5.non_equi join
| Is This Answer Correct ? | 1 Yes | 2 No |
Answer / niranjan.b
In sql joins are 3 types
1.Inner join
2.Outer join
a)left outer join
b)right outer join
c)full outer join
3.Cross join
| Is This Answer Correct ? | 0 Yes | 2 No |
Answer / guruswamy
join is combaining two or more tables.
there are three types.they are
1).simple join
2).self join
3).3.outer joins
| Is This Answer Correct ? | 15 Yes | 21 No |
Answer / ron
looks like one important is left out:
guess what it's
cartesian join.
| Is This Answer Correct ? | 12 Yes | 35 No |
how to retrieve 1st and last row of table without using group functions??
How to work with data objects interactively?
How to add another datafile to a tablespace?
How to set a transaction to be read only in oracle?
What is save point in oracle database?
What is the dynamic sql in oracle?
what is difference between DBMS and RDBMS?
How to create a new table in your schema?
How to define an oracle sub procedure?
which is best insttute for teradata,sybase,mysql,oracle in hyderabad
How to convert character types to numeric types?
What is SGA ? How it is different from Ver 6.0 and Ver 7.0 ?
Oracle General 
