Skip to Content
0
Former Member
Jan 13, 2012 at 07:26 PM

Outer Joins Generated in SQL but not specified in Data Foundation

23 Views

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