![]() |
|
首页 │ Apache │ Linux│ Java│ MySQL│ 注册│帮助 | |||
相关问题
select
products_to_categories.products_id, categories_id, products_price, products_image, products_model, products_name, products_description
from
products_to_categories, products_description, products
where
products.products_id = products_to_categories.products_id
AND products_description.products_id = products_to_categories.products_id
AND categories_id = " 1 "//这里是商品分类id为1的分类.
AND products_description.language_id = $languages_id
AND products_price != 0
AND products_status = '1'
order by products_name
AND categories_id = " 1 "//这里是商品分类id为1的分类.
如果(条件)要查询categories_id =1 和30 45 9 8等值的sql语句怎么写
提问者:zzyanglin 08-15 09:09
答复

