Pass result of a SQL query to another SQL query

You can use subqueries or Joins for this. For ex -

SELECT * FROM tbl1 WHERE tbl1.col1 IN (SELECT col2 FROM tbl2)

SELECT tbl1.* FROM tbl1 JOIN tbl2
ON tbl1.col1 = tbl2.col2