Re: [SQL] 9.0rc1 - query of view produces unexpected results

2010-09-14 Thread Nathan Grange
Doh!! Files attached this time. On 09/11/2010 07:31 PM, Nathan Grange wrote: Hello list, I don't know if it's me, or maybe even the way I designed these dependencies, but I'm getting unexpected results when i query a specific view. I can only reproduce the unexpected resu

[SQL] 9.0rc1 - query of view produces unexpected results

2010-09-11 Thread Nathan Grange
Hello list, I don't know if it's me, or maybe even the way I designed these dependencies, but I'm getting unexpected results when i query a specific view. I can only reproduce the unexpected results with a very specific set of tables, views, and relationships. The bad results are only manif