>>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.
>Joe,
>
>Assuming the table names of Members (everyone) and Visits (the recent visitors) you can;
>
> SELECT ... ;
> FROM Members ;
> WHERE Members.MembNum NOT IN (SELECT MembNum FROM Visitors) ;
> ...
Thank you Ill give this a try it looks like what I need.