Hallo Reinhold,

...
Where status='I' and datum8 > 0 and datum8 in(select datum8 from lib.file1)
...

oder

Where status='I' and datum8 in(select datum8 from lib.file1) and datum8 > 0


Gruß

Torsten