difference between join and union in reportstudio?
Answers were Sorted based on User's Feedback
Answer / palzkumar
UNION is one of the set operator, which is to apply one or more queries, that results in a projection list on which other queries can be based.
JOIN is not a set operator, but it's used to joins two queries with various relationship's cardinality.
| Is This Answer Correct ? | 1 Yes | 0 No |
IN REPORT STUDIO JOIN IS USED TO JOIN TWO TABLES AND
UNION IS USED TO JOIN 2 REPORTS OR QUERIES.
SHARATH
| Is This Answer Correct ? | 9 Yes | 9 No |
How do we run stored procedure?
what is mean of Meta data definistions?
How to perform single signon in Cognos by using URL?
hi frnds any body have cognos projects plz send me two(or)three projects to my mail adress ramureddy.reddy4@gmail.com.
Is it possible to join multiple Databases in a Catalog?
What are the two types of framework manager?
What is limited local? and the uses?
How to create a completed dashboards in cognos report studio? and how to change the bar colours for differencet columns in bar charts?
What is Portal Tab?
How create measures and dimensions?
What are all the types of report?
how can i test the reports in cognos