select top 12 id,pname,pbtype,pstype,ppinpai,pyuanjia,pxianjia,simg_path from products
where islock=false and istuijian=true and ppinpai in ('THE FACE SHOP','兰芝','宝丝尔','三星','婵真')
order by istuijian,id desc
--------------------------------这个语句我取不出数据来select top 12 id,pname,pbtype,pstype,ppinpai,pyuanjia,pxianjia,simg_path from products
where ppinpai in ('THE FACE SHOP','兰芝','宝丝尔','三星','婵真')
order by istuijian,id desc
--------------------------------但是我只加一个限定语句的时候就好用我想把那两个限定语句都加上,请问如何解决
非常感谢
where islock=false and istuijian=true and ppinpai in ('THE FACE SHOP','兰芝','宝丝尔','三星','婵真')
order by istuijian,id desc
--------------------------------这个语句我取不出数据来select top 12 id,pname,pbtype,pstype,ppinpai,pyuanjia,pxianjia,simg_path from products
where ppinpai in ('THE FACE SHOP','兰芝','宝丝尔','三星','婵真')
order by istuijian,id desc
--------------------------------但是我只加一个限定语句的时候就好用我想把那两个限定语句都加上,请问如何解决
非常感谢
tryselect top 12 id,pname,pbtype,pstype,ppinpai,pyuanjia,pxianjia,simg_path from products
where islock=0 and istuijian=1 and ppinpai in ('THE FACE SHOP','兰芝','宝丝尔','三星','婵真')
order by istuijian,id desc
数据库为access