|
select g.*,p.prov_id from ex_gyjx_prod g,ut_pub_prov p
where
g.pdt_province = p.province_name
AND g.pdt_city='ALL'
AND g.pdt_value in (10,20,30,50,100,200,300,500)
AND g.pdt_min = '5'
AND p.prov_id <> '0'
order by g.pdt_isp,p.prov_id,g.pdt_value
其中 “ <> ” 是不等于的意思 | 
转播
