Re: Outer Joins & Limits w/BrioQuery?

I think you should have created a right outer join instead; "Retrieve all rows from ALUMNI_DEGREE (that falls within my limit) and those rows from ALUMNI which have matching joined column values." The left outer join
explicitly says "retrieve all 5,000 rows from ALUMNI" and since you put no limit
on any field of that table you get all 5,000. These 5,000 rows is then matched
to ALUMNI_DEGREE and filling in with nulls where no match is found. The "AND AL4.YEAR_AWARDED(+)='1996'" actually says "Give me all rows that has
YEAR_AWARDED equal to '1996' but also give me rows of NULLS where YEAR_AWARDED
is not '1996' ". If you do a right outer join the plus sign should disappear.

Regards,
Roland Svensson.

Jon Derman wrote:
> .....
> There is a one-to-many relationship between ALUMNI and ALUMNI_DEGREE.
> The two tables are related based on EXTRACT_DATE, CAMPUS, and
> IDENTIFIER. I build that join in Brio, connecting the two topics by
> EXTRACT_DATE, CAMPUS, and IDENTIFIER, and I set the Join Type for
> those three connections to 'Left' (i.e., "Retrieve all rows from
> ALUMNI and those rows from ALUMNI_DEGREE which have matching joined
> column values.").
> ......
Received on Sat Sep 13 1997 - 00:00:00 CDT