on 04-14-2016 2:41 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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:
How to join three tables in SQL query – MySQL Example
Thanks,
Mahboob Mohammed
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.