Select and update in same stored procedure and using result of select to update some value

Select and update in same stored procedure and using result of select to
update some value

Is there anything like
select Column_n from table1;
update table2 set column_m where column_a=Column_n ;
Which can be written in "same stored" procedure