First time to write Oracle SQL two table links query

My SQL is very poor, half a day response to, was a colleague joke. Oh, ah ah. Must surpass him later!!

Table Shop

Pk_shop PRIMARY Key

Name Commodity

Shop

Pk_shop	Name
001	Down
002	Coca - cola

Bpm_ll_test2

PK_BPM_LL_TEST2 PRIMARY Key	Sname Product Name
01	001

Select (select name from shop where shop s s.pk_shp = a.sname) from Bpm_ll_test2 A;

First time to write Oracle SQL two table links query