cancel
Showing results for 
Search instead for 
Did you mean: 

Universe Designer in BO 4.2 - Oracle SQL Join made by 3 tables

Former Member
0 Kudos

Hi There,

I'm using BO Universe Designer in 4.2 and I was wondering of you create a join made by three tables

Is it possible?

Many thanks

Ercole

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Hello Ercole,

I would also recommend to create a view based on your requirement at the Database level and just pull that view in your Universe so as to avoid overhead of joining tables at universe level.

If the data is on the higher side we can always go with Materialized View.

Regards

Niraj

mhmohammed
Active Contributor
0 Kudos

Hi Ercole,

Why don't you create 2 joins separately? A join between 2 tables (A,B) first, another join between 2 tables (B,C)?

What's the requirement? What's the relationship between tables? What does the data look like? Some more details can help us to help you better.

Check these out:

http://stackoverflow.com/questions/4892267/oracle-join-3-tables-which-way-is-efficient-or-is-there-a...

How to join three tables in SQL query – MySQL Example


Thanks,

Mahboob Mohammed