What is a join and explain different types of joins?

Question Posted / guest

2 Answers
4842 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

What is a join and explain different types of joins?..

Answer / dhivya

Joins are used to fetch the records from more than one
table ,there are 4 types of joins
1.Equi-Join
2.Non-Equi-join
3.outer-join
4.Self-join

Is This Answer Correct ?

3 Yes

2 No

What is a join and explain different types of joins?..

Answer / kavita

Join are used to link then retrive data from same or
different database(both have atleast one common attribute).

Join are basically of two types:
1)Equi Join
2) Non equi join

Equi join are those in which we use "=" operator in
condition.They are further divided into
a)inner join:-In this only those rows are return which
satisfy the condition.

b)Outer join:In this all rows are return in which either one
table satisfy the condition
Outer Join are again classified into left join and right join.

2)Non Equi Join are those in which we use ">","<",">=","<="
operator for retriving tuples from two tables

Is This Answer Correct ?

1 Yes

0 No

Post New Answer