Seeking simple SQL statements

l84131421

Find the merchant id according to the conditions, and then find the regional id based on the found merchant id
Finally, I need to find the business id and area id, and I want to complete it in one sentence, help

Business table shangjia, area table diqu, everyone help

l84131421

up

ilgold

select b. region name, a. business name from business as a left join region as b on a. region ID = b.id where a. condition field = condition