Matt Froncek wrote:
There must be a bug then. Because my TimeTracking Table has 36,000 records
and that is what I get with the First LEFT OUTER JOIN and even with the
second LEFT OUTER JOIN but adding the third one I get 2,000,000 records. The
product of 36,000 and the records duplicated from PriceLevelPerItem).
Any suggestions?
Matt,
That does sound like a bug. It seems like it is doing an inner join for
the last left join which is matching customer table columns from the
extended intermediate table to the pricelevelperitem table.
Does this fail for small sample tables? Can you post your table schemas?
You should probably file a bug report if this is confirmed.
I'm a little concerned now because I do very similar left joins of
multiple tables in my application. I haven't noticed a problem though.
HTH
Dennis Cote
