Hi Milan;

OK, I tested your sintaxis (my sintaxis and Set' sintaxis, both
return 155 rows, and your way returns 188). Here you have the results:

Starting transaction...
Preparing query: select p.PROC, p.EXP1 as EXPE, p.ACTO, p.DEMA,
p.OBSE, t.DSCR as D_TPRO
from PROC p
join MOVI m on p.PROC = m.PROC and m.TIPO = 'B'
left join TPRO t on p.TPRO=t.TPRO
order by lower(p.ACTO)
Prepare time: 00:00:00.
Field #01: PROC.PROC Alias:PROC Type:STRING(10)
Field #02: PROC.EXP1 Alias:EXPE Type:STRING(18)
Field #03: PROC.ACTO Alias:ACTO Type:STRING(200)
Field #04: PROC.DEMA Alias:DEMA Type:STRING(200)
Field #05: PROC.OBSE Alias:OBSE Type:STRING(120)
Field #06: TPRO.DSCR Alias:D_TPRO Type:STRING(120)
PLAN JOIN (SORT (JOIN (P NATURAL, M INDEX (MOVI_PROC))), T INDEX
(TPRO_PK))


Executing...
Done.
435414 fetches, 8 marks, 142469 reads, 8 writes.
0 inserts, 0 updates, 0 deletes, 154627 index, 33586 seq.
Delta memory: 48028 bytes.
Execute time: 00:09:45.