New query based on SOME fields returned in another query

I need to have two queries, the second query uses some information from the first query but the second query's results is not a subset of the first query.

this is my first query

select name, date, company, valid
from tbl1, tbl2, tbl3
where valid=0

Then I need to take the person's name to do another query, but I don't need to look in the first set of results to get what I need. It is a brand new query just with the name as the parameter.

select name
from tbl4
where name = @.name

Right now I have the second query getting it's parameter from the first query in RS. The two queries are two different data sets BUT my second query is limited by the results from the first query. How do I get the second query to be it's own query not based on the first but get a parameter from the first query.

I know this is all very confusing. I apologize. I am trying to explain fully.

Please help, I am new to RS and quite new in SQL

Well, I think I solved my problem. I needed to create a sub report.