Question Get Value from other Table

[tqmd1]

Dear Developers

SQL, Table CODE has data as following

Code------product
1-----------Mango
2-----------Potato
3-----------Orange

SQL, Table SALE has following data

Code------Product
2-----------
3-----------

I want to fill sale.product column with code.product columns as

Code------Product
2-----------Potato
3-----------Orange

What query should I USE?

Please help