>>>>I use a health care app with vfp as a engine. I have a table of insurance members who have seen their pri. care
>>>>physician in last 12 months . I also have a table of all the members in general . How can I extract the members
>>>>who have not seen their pri. care physician. Using member number , last name , first name , expiration date fields etc.
>>>
>>>
>>>SELECT Member.number, Member.LastName, Member.FirstName, Member.etc ;
>>> FROM Member, Insurance ;
>>> WHERE Member.Number NOT IN( SELECT Insurance.Number FROM Insurance );
>>> INTO SomeTableOrCursor
>>>
>>>:0)
>>
>>I have tried this but it churns on it for 30 minutes and comes back with not enough disk space in /temp. I also set up a 2 giga byte
>>drive as / temp and mapped it in vfp option -data section. total member count in general is 22,000 people who have seen
>>pri care physician is about 14,000. Do I need a Cray supercomputer to do this?????
>
>Joe,
>
>There's a slightly different version of the above that might work. Try
>
>SELECT * ;
>FROM Member;
>WHERE NOT EXISTS;
> (SELECT * FROM Insurance WHERE Insurance.Number = Member.Number);
>INTO SomeTableOrCursor
>
>HTH,
>
>George
I Did this and it worked fine; tried several other suggestions to no avail. Thank you very much you saved my day.