How to get the list of patients based on 3 fields by using subquery

[stalk]

I have about 8 patients with at least 6 to 10 records per patient. PID is different but the Patient fname, lname and state remains same . How can I filter them and extract all the records for these patients, say about 150 records?
In regular cases using pid I can get using this query select * from ptable where pid in(select pid from table2).



Thank you

[June7]

Are you saying the same person has multiple PID? You need to use combination of fname/lname/state as filter criteria?

[ranman256]

use a tPicked table for a user to pick the patients from a list. (add a box to filter list by name)
once all are picked (dbl-click runs append query to add the PID to the table)

then the main data query joins the tPicked table to the main data vid PID, and only those patients are shown.