On Mon, Mar 15, 2010 at 4:22 PM, Pascal Gienger < pascal.gien...@uni-konstanz.de> wrote:
> Using this result to reconstruct the first left outer join from the initial > statement, I get this result: > Not so much a bug as a missing feature: the parser is currently unable to recognize any subselect as being fully independent, and will thus execute it for each and every row in your primary select. You may or may not get better results by rewriting it so the subselect is a virtual table. If that doesn't help, subselect into temptable and use that, or do the reconstruction in code, or other dirty tricks. YMMV. -- Bier met grenadyn Is als mosterd by den wyn Sy die't drinkt, is eene kwezel Hy die't drinkt, is ras een ezel