on 09-01-2015 10:49 AM
Hi,
Using bo4 sp08 and have 2 derived tables in a simple universe - these are joined to each other and the join is present in a context.
When select objects from each rather than one sql being generated as I would expect it is generating a full outer join when view the sql.
Any reason why this is the case?
Want just single sql.
Thanks
When you say it's generating a full outer join, I supose you mean you have in fact just 1 sql statement. Joining 2 derived tables will result in one query with 2 inline views in the where clause :
SELECT ...
FROM
(SELECT ...
FROM ...) derived1,
JOIN
(SELECT ...
FROM ...) derived 2
ON derived1.key=derived2.key
That is, if the join is in the context.
Or do you have 2 seperate sql statements (that are synchronised at the report level) ?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
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.