>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)
If we exchange an apple, we both get an apple.
But if we exchange an idea, we both get 2 ideas, cool...Gérald Santerre
Independant programmer - internet or intranet stuff - always looking for contracts big or small :)
http://www.siteintranet.qc.ca