MySQL Query Not Working

See more:

MySQL

I am trying to retrieve values from two tables in my PHPMyAdmin database.

I am not great with MySQL, and tried the query below to no avail.


I need to retrieve the Products ID and Price from the Products table, and the Product Options Values Name from the Products Options Values table.


There is no direct link between the two tables, and so I tried retrieving the values linking through different tables, however this is obviously incorrect.

SELECT p.products_id, p.products_price, o.products_options_values_name

FROM products p, products_options_values o

WHERE p.products_id = products_attributes.products_id

AND products_attributes.options_id = products_options_values_to_products_options.products_options_id

AND products_options_values_to_products_options.products_options_values_id = o.products_options_values_id

ORDER BY `products_id` ASC

Any help would be great. Thanks