Dmitry,

After reading your answer, I thought to try changing the order of the things and it Works very quick (I have to check if it Works for my purposes, but it seams it will work). I can´t understand why it Works fine this way but not in the other:

Starting transaction...
Preparing query: select t1.*, t2.* from

(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") t1

left outer join

(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") t2

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

order by t2."TKEY",t1."TKEYT"
Prepare time: 0.018s
Field #01: TL1_2.BJTX Alias:BJTX Type:STRING(10)
Field #02: TL1_2.TKEYT Alias:TKEYT Type:STRING(20)
Field #03: BJTX.OWNR Alias:TOWNR Type:STRING(10)
Field #04: BJTX.BJAR Alias:BJAR Type:STRING(10)
Field #05: BJTX.DSCR Alias:TDSCR Type:STRING(400)
Field #06: BJTX.VOCE Alias:VOCE Type:STRING(400)
Field #07: BJTX.RICH Alias:RICH Type:STRING(1)
Field #08: BJTX.TEXT Alias:TEXT Type:BLOB SUB_TYPE 0
Field #09: TL1_1.BJAR Alias:BJAR Type:STRING(10)
Field #10: TL1_1.TKEY Alias:TKEY Type:STRING(80)
Field #11: BJAR.OWNR Alias:OWNR Type:STRING(10)
Field #12: BJAR.TIPO Alias:TIPO Type:STRING(1)
Field #13: BJAR.DSCR Alias:ADSCR Type:STRING(200)
PLAN SORT (JOIN (JOIN (T1 B1 NATURAL, T1 B2 INDEX (BJTX_PK)), JOIN (T2 A1 INDEX (TL1_1_PK), T2 A2 INDEX (BJAR_PK))))

Executing...
Done.
1502539 fetches, 18 marks, 20034 reads, 18 writes.
0 inserts, 0 updates, 0 deletes, 227984 index, 91644 seq.
Delta memory: 60898428 bytes.
Total execution time: 1.546s
Script execution finished.