what is a join? what are the types of joins?
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
What is the difference between macros and prompt?
Can any one tell me cognos training class in chennai? thanks in advance...
what is an associated query?
Can we provide Package level security to two different groups i.e for finace and HR depts should access only their data??
how to do page breaks in cognos 8 Report studio pls give the navigation
what is the procedure for scheduling conditional rendering?
I want to display popup menu or alter message in my report? How to you solve this problem? Give me the answer with example?
What's use of a Master Detail report in Cognos? I mean what's the advantage? Please Explain.
Can you explain the advantage of using shortcuts?
-----------------What is Singleton?
1 Answers BoA, Cap Gemini, TCS,
Which studio is used to create reports?
3.User1 doveloped some report,user2 modify the same report and user 3 also updates in that same report? how to identify that report will be modified or not?
1 Answers IBM, Thomson Reuters,