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