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......