>Just got a very surprising error message. "SQL: Queries of this type are not supported"
>
>

>SELECT * ;
>  FROM Table1 ;
> WHERE FieldX NOT IN (SELECT FieldX FROM Table2) ;
>  INTO TABLE (lcTable3Name)
>

>
>Is the NOT IN not supported or is there another reason that I am missing?
>
>TIA,
>
>Alex

Post the exact query you're trying to execute. I think there must be another reason.