Answer Posted / srini
Some times the main query needs a driving query in FROM
clause, which is not possible to build. So we use derived
tables to fix this.
Example:
SELECT
----
FROM
TABLE1,
( SELECT
---
FROM
TABLE2
)DERIVED_TABLE
WHERE
TABLE1.COLUMN = DERIVED_TABLE.COLUMN;
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
any difficulitis have you phase while creating bo reports and how did u solve it
what are the day to day activities of BO administrator ?
What is the difference between the public object&schema object?
If 2 tables are joined by Shortcut join, if query is generated based these join, what will be the join type and what will be the generated query? Thanks in advance?
Hi, What is the best answer for tell me about yourself for 2 years experience in bo developing.
If there are no indices defined on any of the columns in the above two tables, which columns would you index to speed up the left join query?
What is the functional & architectural differences between business objects and web intelligence reports?
Explain the difference between detect alias and detect context?
What is the difference between business requirement document and use case document.
What is package in BO
What are the join problems comes appart from loop,chasm & fan Traps
What we need to discuss with designer before starting the universe designing.
Can we configure two instances of CMS pointing to two different CMS system databases?
Explain how many universes can be created in a project?
What Is Snow Flake Schema?