is it possible to select all the data in one table based on a criteria from another table?
for instance i want to select all the therapist from massage_therapist WHERE massage_schedule.finish > 0.
i don't want merged results. i just need to list all therapist based on the where criteria from a different table.
these two tables have the therapist_id in common.