Hi,
Try

SELECT * FROM main2 WHERE file_date.... 

>hi,
>this is my mistake,
>

>SELECT * FROM FILE main2 WHERE file_date NOT IN (SELECT file_date FROM mstr)
>

>thanks
>>Hi,
>>
>>

>>>>  SELECT * FROM FILE(main2) WHERE file_date NOT IN (SELECT file_date FROM mstr)
>>

>>
>>What do expect this to do. FILE() returns a logical value......