Inner Join example in MySQL

Suppose we have two different tables in Database, one having product ID and product name and the other having product ID and price, as shown below,

Table_1

Table_2

then to show the product names with their price, we can write an SQL statement (Inner Join) like this,

SELECT a.product_name, b.product_price FROM Table_1 a, Table_2 WHERE a.product_id=b.product_id;

This would give you the result as,

Related posts:

1. Common mistakes and points to remember in MySQL