Hello ib-support@yahoogroups.com!

1.

SELECT * FROM POKLADNA
WHERE JEDIN IN (SELECT RECORD_ID FROM SYS$REP
WHERE TABULKA='POKLADNA' AND
ZMENA<>'D' AND
JEDIN>40000
);


2.

select *
from pokladna a
join sys$rep b on b.record_id=a.jedin
and b.tabulka='POKLADNA' and b.ZMENA<>'D'
and b.JEDIN>40000;

So ?

--
Best regards, TRoland
http://www.rotursoft.sk