Join function of Database

[eluser]Desmond[/eluser]
<Solved, thanks everyone>

Hello everyone, just a simple question but I can't solve it for long. Please help. Thank you so much.

I have two tables in database

Table_A : Shop_id | Shop_name,
3 | ABC shop
5 | DEF Shop

Table_B : Shop_id | Price
2 | 10
5 | 15

How can I get the Shop_name (DEF Shops) form table_A if I have input Price =15?

can I use the join function to achieve this?

Thanks again;-)