>>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)
Gerald,
You ahve to drop Insurance form the FROM clause or else you are creating a cartesian product of Members to Insurance.