How can I use output from one query to take results from 2nd table

See more:

Oracle

Select name, Id from table1;

 select colum1,colum2 from table2 where name='' and id='' ----output from the first table

need to take the output from the table2 from all the values from table1

What I have tried:

need to join the fist query with the second and take the output