Interested to Buy Any Domain ? << Click Here >> for more details...
What are joins..how many types of joins are there?
- 29 Answers
- 97208 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 |
Can we create database in oracle using command line ?
normally database take to refresh time 2 hours. but client asked iwant to refresh with in 5 min that same database. do you have any option in BO and Oracle? explain me briefly...kavi
What is Network Database link ?
What is the usage of control file in oracle?
Can objects of the same Schema reside in different tablespaces.?
How translate command is different from replace?
How to load excel data sheet to oracle database
How to login to the server without an instance?
How can we force the database to use the user specified rollback segment?
what is the need of indexing topic in oracle? where do we use in a Java project? any other option other than using this to get the same result where we use indexing ?
What is the difference between Sleep and Wait? (Java)
Describe the different type of Integrity Constraints supported by ORACLE ?
Oracle General 
