Hi Malcolm,
It's hard to tell which query would be faster w/o running tests that why I sugested the alterenatives. Is difference significant enough to prefer correlated subquery over two others?
>
>I added some additional logic to my sql select and found that your correlated sub-query is starting to perform much better than my original query.
>
>Thanks (again!) for your help - very much appreciated!
>
>
>
>
>* your correlated subquery suggestion that I'm using
>select curWord.cWord from curWord ;
> where NOT EXISTS ( select * from curDictionary ;
> WHERE curDictionary.cWord = curWord.cWord ) ;
> into cursor curMisspelled
>
--sb--