创建一个sql变量并查询其他表

I'm trying to query a table and get the results into a variable. With the variable results do another select query using the variable details as the filter.I'm trying to query a table and get the results