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如何定?请指教!

作者: 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