How Assigning query return value to local a variable, and how to use that in where condition?

Question

Select Meterial_Id from transaction where CustId=1;

Instead of Meterial_Id i need to get the Meterial_name from Material table.....