>I know I can do :
>Select * from Table
> Where Field In(Select Field From AnotherTable)
> Into Cursor.....
>
>Why can't I do :
>
>Select * from Table
> Where Field !In(Select Field From AnotherTable)
> Into Cursor.....
>
>Or can I ?.
>
>Thanks
>Rob
Hi, try:
SELECT * FROM Table ;
WHERE Field NOT IN (SELECT field FROM table)
or
SELECT * FROM Table ;
WHERE NOT Field IN (SELECT field FROM table)