SQL query output as input to other query

Hi All,

I have SQL query which has just one input . Output from this query (one column) I would like to use as input to another query (all records). Is it possible?

Both queries are taking data from different DB.