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

Answer / uma

What about inner join?is it not included?

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.

Answer / abd hfz

Inner join is also called as Equi Join.

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)

Helow, i have a problem with runing-total function when i use it for a calculate row (for example : i need to diplay a running-total of total units ?)

0 Answers  

What is a Complex report and explain?

4 Answers   IBM, Satyam,

There are some reports,we have to provide security to that reports like the hr manager should have access to hr department reports only and the accountant should have access to accounts reports where as the CEO can have access to all the reports. How to deal with this situation using Cognos?

2 Answers   BitWise,

Define catalog in cognos and write its various types?

0 Answers  

I have prompt date prompt (from and to), country and city, how to get data from jan1/2012 to jan31-2012.

2 Answers   IBM,

What is the difference between Open Connection command ang Open Session Command?

0 Answers  

How to create Events?

1 Answers  

can anybody tell me when do use 'running total'...give an example for the usage of running total

2 Answers   EDS,

---------------Describe OLAP Reporting and RDBMS Reporting?

0 Answers   Bank Of America,

What is the function of cognos dispatcher?

0 Answers  

what is an sid (surrogate key)?

4 Answers   IBM,

What are all the types of report?

0 Answers