Hi all,

This has been bugging me quite a lot. I have a select query with a right outer join that connects two ODBC tables (A -->B)together.

Somehow, the maximum number of rows A returns is 50000, there should be a lot more that it isn't returning. Then when it gets further filtered by the outer join, it leaves me with 1000ish rows.

My intention is to have A return say 200000ish records, and filter by the outer join to B into 5000ish rows.



I have my screenshot attached.