Hi:
I created a very simple universe on a MS Access database. there are four tables, joined by equi joins. Yet, when I select the objects (one from each table), the generated SQL has outer joins! This was not the case in XI 3.1 using Designer. Has anyone else run into this?
I tried to create a similar scenario with SQL server and I got the same issue.
Here is the generated SQL from the MS Access based query:
SELECT
Country.country,
Region.region,
City.city,
Customer.first_name,
Customer.last_name
FROM
Country,
Region,
City,
Customer,
{ oj Country LEFT OUTER JOIN Region ON Country.country_id=Region.country_id },
{ oj Region LEFT OUTER JOIN City ON Region.region_id=City.region_id },
{ oj City LEFT OUTER JOIN Customer ON City.city_id=Customer.city_id }
Notice all the outer joins -- they are not specified as outer joins in Data Foundation yet Webi Rich Client continues to generate the outer joins.
Thanks!
-Mike