On 12/29/05, Adrian Holovaty <[EMAIL PROTECTED]> wrote: > I remember there being a good reason for this, but I don't recall the > exact reason at this point... :-( > > At any rate, feel free to play around with a patch (and some > accompanying unit tests) to see whether you can remove the > table-aliases if they're unneeded.
Ask, and ye shall receive :-) I've just submitted Ticket #1136 that removes table join duplication. Enjoy. And yes - there is a reason for the aliases - so you can resolve circular table references. e.g., "Article has a Reporter has a favourite Article" requires an article-reporter join, and a reporter-arcticle join, but the article table cannot be reused. To get around this, I've implemented an alias naming scheme that is derived from the query itself (rather than a stateful table number). See the ticket for full details. Yours, Russ Magee
