On Thu, 24 Oct 2002, Tomasz Myrta wrote:
> Now I know the solution - to speed up this query I have to manually
> expose field from sub-query. It works fine, but I still don't know why I
> can't do this opposite way.
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.
