How can we acheive Correlated sub-query in Designer?
Answer Posted / prabha
A correlated subquery is a SELECT statement nested inside
another T-SQL statement, which contains a reference to one
or more columns in the outer query. Therefore, the
correlated subquery can be said to be dependent on the
outer query. This is the main difference between a
correlated subquery and just a plain subquery. A plain
subquery is not dependent on the outer query, can be run
independently of the outer query, and will return a result
set. A correlated subquery, since it is dependent on the
outer query will return a syntax errors if it is run by
itself.
| Is This Answer Correct ? | 5 Yes | 17 No |
Post New Answer View All Answers
How to open a universe with out using the Designer ??
Explain is there any tool that can compare two unvs / two rpts , built using bo 5.1 / bo 6.5?
Explain how to execute the plsql procedure from the report by clicking with mouse?
Explain what if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?
WHAT ARE THE META DATA TYPES?WHICH META USING IN BO'S
How would you format some text using css to be verdana and bold?
What are the steps to do to use alerts in bo?
How to schedule the report in b.o?
How to create a new calendar in CMC? Can u please tell me the process to create the required calendar. Ex:- Year of that calendar to start with Jan-15 and ends with Jan -30 and the Next month to start with Feb-31 and ends with Feb-14.
How to Explain about BO projects in interviews?(in Banking,insurance,Manufacturing domains)
Difference between zabo and webi?
What is the profile and package?
What is the difference between absolute and relative div positioning?
Differences between business objects and web intelligence reports?
U r project in which stage in implementation?