General information
Category:
Coding, syntax & commands
>>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.
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only