sql - Transform SELECT statememnt to JOIN -

i have sql statement :

select a.status_id,        (select batch_name           pf_req_batch          batch_id = (select batch_id                              pf_m_req_batch                             request_id = 282)) batch_name   pf_request  request_id = 282;  

i need transform using join. help, plz!

you can try this:

select r.status_id, b.batch_name pf_request r inner join pf_req_batch b on b.batch_id = r.pf_m_req_batch.batch_id request_id=282;