I can not figure out how to do this. I have 3 tables (blProject, upProject, TASKS). TASKS has all the information i want. The other two tables have are needed to narrow down the results. the tables look as follows.

tbl blProject
----------
proj_id

tbl upProject
----------
proj_id

tbl TASKS
----------
proj_id
act_id
proj_name
start_date

So tbl TASKS has over 100 proj_id I want to narrow it down to 2 using the blProject and upProject. Once I have that narrowed down there their will be some duplicate act_id. I want to show those that are not duplicated. So if the result is sam,sam,tom,jerry,sam for act_id the result will only be tom,jerry.

Can anyone figure this out or do i need to create 2 querys then compare the 2?