Re: [PERFORM] Sorting when LEFT JOINING to 2 same tables, even

2004-03-11 Thread Stephan Szabo
On Thu, 11 Mar 2004, Octavio Alvarez wrote: > > Hello to everybody. > > I ask your help for a severe problem when doing a query that LEFT JOINs > one table to another ON a field, and then LEFT JOINs again to another > "instance" of a table ON another field which stores the same entity, but > with

[PERFORM] Sorting when LEFT JOINING to 2 same tables, even aliased.

2004-03-11 Thread Octavio Alvarez
Hello to everybody. I ask your help for a severe problem when doing a query that LEFT JOINs one table to another ON a field, and then LEFT JOINs again to another "instance" of a table ON another field which stores the same entity, but with different meaning. I include 3 EXPLAIN ANALYZEs: * The f