Answer Posted / rakesh
By using outer join we have to display both the matching and non matching records from both the sides(tables).
and in this we have three conditions
left,right and full outer joins.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
write a query to display the departments with no employee?
what are the features in cognos8ui
5. Which type of report you build more, list, crosstab or chart and why?
Explain is there any comparison available for cognos reportnet vs crystal reports?
Write various indexes used in cognos?
Define cognos report net?
Hi All, Is there any way to check whether a value is selected in a Multi-select tree prompt? I have a tree prompt and want to get to know whetehr which values user has selected,i want to so that values on the top of the report. I Have used that paramDisplayValue('paramername'),But it will display only last selected value. For Example i have tree prompt with one level Region- >country->states If user select region Asia it will dislay the all the Countries in that region and then if user select India it will display the states related to india only Suppose Hierachy look like this: Asia->India->Andhra Pradesh. I want to show this hierachy on the top of the report How it is possible? Can you please help me?
What is the advantage of using shortcuts?
how u burst the reports? if u r bursted reports is not reached to destination how u identify???
Hi all... how can we publish packages using bmp scripts to Path:Public Folder Packages Folder
What is looping and how to avoid it in framework manager?
Why is auto-regression used in forecasting used on cognos platform?
what are the components in the cognos connection page consists (eg: my folder, public folder,directions, schedule management tool etc.....)
What are the types of security?
is there any difference between operational database and data base?if yes what r they?