This was was my old FB1.5 query:
SELECT COUNT(*) FROM ERSINVOICE WHERE ERSINVOICE.FKBATCH IN
(SELECT ERSVOUCHERBATCH.ID FROM ERSVOUCHERBATCH WHERE
ERSVOUCHERBATCH.FKEXPORTLOG=ERSBATCHESLOG.ID)

can someone throw this into the EXISTS syntax? I'm having a brain explosion
I'm tryin to get
THE NUMBER OF INVOICES
WHERE THE INVOICE BATCH NUMBER
IS IN THE LIST OF BATCH IDS WHICH ARE IN THE BATCH LOG

 regards
 Alan McDonald