Custom Query

[Prellyan]

Hey there,

I am trying to join the product attributes to the product ID using a seperate custom sql query(ies).

I cant seem to find what id field links a product attributes to the product id.

any help would be greatly appreciated.


It seems that the products_attributes.options.id should = products_options_values_to_products_options.products_options_id

but one field is options_id and the other is products_options_id

is this just a different name for the same data in the two tables??


Thanks