jpi多表联查_SQL如何实现多表联查？

先有数据库zen-cart,有表products,products_attributes和products_options_values其中，products表有products_model,products_id。products_attributes表有products_id和options_valu...

先有数据库zen-cart ,有表products ,products_attributes和products_options_values

其中，products 表有products_model,products_id。products_attributes表有products_id和options_values_id 。products_options_values表有options_values_id，products_options_values_name

首先，我已经筛选products_attributes表中符合的条件了。

select products_id,options_values_id

from products_attributes

where products_attributes.options_values_id LIKE '0'

or products_attributes.options_values_id LIKE '15'

or products_attributes.options_values_id LIKE '16'

or products_attributes.options_values_id LIKE '17'

or products_attributes.options_values_id LIKE '26'

or products_attributes.options_values_id LIKE '27'

or products_attributes.options_values_id LIKE '28'

or products_attributes.options_values_id LIKE '29'

or products_attributes.options_values_id LIKE '30'

or products_attributes.options_values_id LIKE '31'

or products_attributes.options_values_id LIKE '32'

现在我该如何把这筛选的结果联合products和products_options_values呢？

最后输出的结果分别为 products_model 和products_options_values_name

展开