Hi all;

select t1.*, t2.* from

(select a1."BJAR",a1."TKEY",a2."OWNR",a2."TIPO",a2."DSCR" as "ADSCR" from "TL1_1" a1 left outer join "BJAR" a2 on a1."BJAR"=a2."BJAR") t1

left outer join

(select b1."BJTX",b1."TKEYT",b2."OWNR" as "TOWNR",b2."BJAR",b2."DSCR" as "TDSCR",b2."VOCE",b2."RICH",b2."TEXT" from "TL1_2" b1 left outer join "BJTX" b2 on b1."BJTX"=b2."BJTX" order by "BJAR") t2

on t1."BJAR"=t2."BJAR"

order by t1."TKEY",t2."TKEYT"

With FlameRobin:

If I only run for searching t1 part, it works super-fast. The same if I run for searching t2 part; but if I run this whole command, Firebird 2.5.3 accepts it, but it never finish (I mean, I waitted more than 20 minutes. The whole query has 83.000 rows.

I tried the same statment under other engines (Postgresql for example) and it runs inmediatly.

Somebody why?. It seems it is very simple.

Best regards.