hi,
thank you so much,
with file, or without file it works,
what is the different .

this code works..

SELECT * FROM main2 WHERE file_date....&& works

SELECT * FROM FILE main2 WHERE file_date .....&&works

thanks

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