最麻烦却最简单易懂的: select * from chj where xh="001" and xh="002" and xh="003" and fs="70" (这是直接用几个且关系并列条件筛选)
还有一种,我有些忘了: select * from chj where fs="70" and xh in("001","002","003","004") (这一种是用IN来书写,包含一下几个数据,in的书写格式我有点忘了,最近一直做的是双表查询,简单的反而忘了) 慢慢来,SQL后面会越来越有趣的,特别是让你编写淘宝的运用程序,很好玩的