INNER JOIN of two tables

if you have two tables like product and product_description  and you want the inner join of these tables then the query will be like this:

select product.model, product_description.name, product.price, product.weight, 
product_description.description from product INNER JOIN product_description on
product.product_id=product_description.product_id