Interested to Buy Any Domain ? << Click Here >> for more details...
what is a join? what are the types of joins?
- 5 Answers
- 10088 Views
- HCL, Satyam, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What do you mean by Drill down and Drill Up?
What are the different uses of a repository manager?
what is power prompt in cognos ep7series?what is the use of this?
What is the diff between the following Report output-- HTML O/P, PDF O/P, EXCEL 2000 and EXCEL 2003 of report outputs? Listout main differences?
What is dtm?
-------------What is Coditional Prompting?
Can you define folder?
1. We have been asked to add summary information to sales reprasentatives performance report. The report needs to be grouped by country and city to compare performance between areas Also we need to include revenue totals for each city and each country.
How to join multiple db in catalog?
I have a reports on cognos ep7series version3 with database SQl2000.Now i am migrating database SQL2000 to SQL2005.Then What happens to cognos reports and also there is reports cubes then how can i handle this problem please give me step by step solution b'coz i am new to cognos ep7series
please please give me some banking calculations in framework manager.
What is meant by drill down?
what is a prompt value in report studio and variables ?
Explain difference between powerplay transformer and power play reports?
What's the limitation of 'Page Footer' in Report Studio? e.g. If I have an activity prompt (list of activities in a Search & Select Prompt) and selected around 2500 activites from the 'Activity' Search & Select Prompt and when I ran the report I got a message "#! Overflow" in page footer. Can somebody please tell me what's max. limit. I tried with around 300 activities and page footer displayed the activities. Your help will be appriciated.
