what is a join? what are the types of joins?

Categories >> Software >> Data Warehouse >> Cognos
Suggest New Category

Question Posted / sekhar

5 Answers
9147 Views
HCL, Satyam, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

what is a join? what are the types of joins?..

Answer / m m naidu

JOIN: A join is a query using which we can query data from
more than one table

TYPES OF JOINS:

1.EQUI JOIN
2.SELF JOIN
3.OUTER JOIN
a.left outer join
b.right outer join
c.full outer join
4.cartesian join

Is This Answer Correct ?

4 Yes

0 No

what is a join? what are the types of joins?..

Answer / uma

What about inner join?is it not included?

Is This Answer Correct ?

1 Yes

0 No

what is a join? what are the types of joins?..

Answer / arkchowdary

Join----------------- Ajoin is fetch the data 1 or more
tables this is known as join.

Types of Joins-------------- Equi Join,
Nonequi join,
Self Join,
Cartesoin Join,
Outer Joins
Leftouter Join,
Rightouter join,
Full outer Join.

Is This Answer Correct ?

0 Yes

0 No

what is a join? what are the types of joins?..

Answer / abd hfz

Inner join is also called as Equi Join.

Is This Answer Correct ?

0 Yes

0 No

what is a join? what are the types of joins?..

Answer / palzkumar

Both are right.. but slight changes... joins is used to
fetch the records/data item from two or more queries (no
tables in cognos) using
type of joins like...

1.EQUI / SIMPLE JOIN (eg. 1:1 = 1:n)
2.SELF JOIN
3.OUTER JOIN
a.left outer join (eg. 1:0 = 1:n)
b.right outer join (eg. 1:1 = 1:0)
c.full outer join (eg. 1:0 = n:0)

Is This Answer Correct ?

0 Yes

2 No

Post New Answer