Answer / vinay

derived tables are logical tables in the universe. to
reduce the query complexity and better query performance or
complex querys we write in derived tables. derived tables
are nothing but sql queries. thease tables can be used in
prompts...

Answer / 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;

whats the diff between break and section

4 Answers   TCS,

---

how to create a derived table in designer? i need steps regarding derived table

1 Answers  

---

Please anybody tell me Is Data integration And ETL programming is same..? Thanks in advance....

3 Answers  

---

In a context can i get the data from two different factables by using the single data provider?

2 Answers   IBM,

---

What is package in BO

0 Answers   Infosys, Saksoft,

---

What three things do you consider to be the most important factors for a manager?

0 Answers  

---

what is the core universe and what is the active universe?

1 Answers  

---

What is the difference between the public object&schema object?

0 Answers  

---

What is the difference b/w breaks and sections

2 Answers   IBM,

---

What is the difference between the Bo 3.0 and 3.1?

1 Answers  

---

how to coneect to a server in a business objects

1 Answers  

---

Hi,can anybody help me to do like this, i have one dp with agerange, first name ,Address. And another dp is agerange,age min , last name. in this two data providers agerange is common . I want to see in my report all the fields . How i can merge it ?

1 Answers  

---