>>>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
George
Ubi caritas et amor, deus ibi est