>I know the nested part of the following SQL is incorrect, but what is the right way?
>
>
>

>SELECT DISTINCT * FROM AllStuff WHERE AllStuff.UserID ! IN (SELECT ExcludeStuff.UserID FROM ExcludeStuff) INTO CURSOR NewStuff
>

Why do you think it is wrong? It looks perfectly ok to me.