Mysql select 语句请教!
sql查询语句如下:
SELECT * FROM `sale` WHERE `client_sn` IN ('102FSDE0', '102FSFY0')AND `goods_sn` IN ('203HMJ01', '303SXZ06', '008BJ000', '404PTT60');
请问如何添加查询条件,使到当`client_sn` = '102FSDE0'时,`goods_sn`字段中含有'008BJ000'值的记录不被筛选出来。
用if语句可行吗? sql如何定?请指教!
SELECT * FROM `sale` WHERE `client_sn` IN ('102FSDE0', '102FSFY0')AND `goods_sn` IN ('203HMJ01', '303SXZ06', '008BJ000', '404PTT60');
请问如何添加查询条件,使到当`client_sn` = '102FSDE0'时,`goods_sn`字段中含有'008BJ000'值的记录不被筛选出来。
用if语句可行吗? sql如何定?请指教!
作者: nationzhou 发布时间: 2011-05-29
SELECT * FROM `sale` WHERE `client_sn` IN ('102FSDE0', '102FSFY0')AND `goods_sn` IN ('203HMJ01', '303SXZ06', '008BJ00O', '404PTT60' and(client_sn!='102FSDEO' and good_sn='008BJOOO') 这个应该满足你的要求吧
作者: yubinding 发布时间: 2011-05-29