> The system doesn't realize that it can limit the subquery when the only
> things it has is the join clause and the limiting clause on the other
> table. Like Tom's message about the other view, it won't imply that
> X.foo=12345 from foo=12345 when the exposed foo is B.foo.
Is this what we should expect, or rather a bug?
The system knows how to join tables, but fails with joining views or
subselects :-(
Tomasz Myrta