Table Order in Inner Joins in MySql Database

We get product details and product status, total sales at one table.

Try it below code......

SELECT product_model  FROM products as p,products_attributes as pa WHERE p.product_id = pa.product_id and pa.options_values_id = 100

or

SELECT p.product_model FROM products p INNER JOIN products_attributes as pa ON (p.product_id = pa.product_id) WHERE pa.options_values_id = 100

• Tweet
• Share
• Share
• Share
• Share

Sign up here with your email