>>>Another thing occurred to me. What about using SEEK() instead of IN()
>>>
>>>SELECT
fields FROM helthins_view ;
>>>WHERE NOT SEEK(ssno,'helth_priors_tmp',
Tag) ;
>>> AND NOT SEEK(ssno,'helth_currents_tmp',
Tag)
>>>
>>>
>>>Might that even be faster?
>>>
>>>HTW
>>>
>>>Matt
>>
>>Matt, I remember MS recommendation not to use functions which switch work areas inside Select-SQL commands (it really can invoke GPF error).
>
>
>Yeah, I think I spoke about that earlier today, but I thought that only applied to UDFs. I was under the impression that the Fox Functions were ok. Does SEEK actually change the work area? That might be a stupid question, I'm just not sure.
>
>Matt
I am not sure too, so I would prefer standard (NOT IN) way.
Edward Pikman
Independent Consultant