Interested to Buy Any Domain ? << Click Here >> for more details...
What are joins..how many types of joins are there?
- 29 Answers
- 97253 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 |
Give the constructs of a package, function or a procedure.
What happens if the imported table already exists?
How to open and close an explicit cursor in oracle?
How to use "while" statements in oracle?
How to work with data objects interactively?
How to install oracle odbc drivers?
The table has 3 columns 4 rows. The output is which column has least null values( A COL SHOULD BE THE OUTPUT) Write the query plz. A B C ================ 1 NULL 2 NULL 3 4 NULL 5 6 7 NULL NULL O/P C = 2 4 6
how to insert data into partitioned table partition done by Range partition
How to create a server parameter file?
what is the use of ondelete cascade?
how to make an oracle object
How to add another datafile to a tablespace?
Oracle General 
