pos界面输入商品款号 搜索出别的款的商品

<p>pos里面按4 回车 输入1CRC1821781 回车 然后出来很多商品 select trim(s.code) as code,trim(d.colorid) as colorid,trim(c.colorname) as colorname,trim(e.xsize) as xsize,s.sizegrpid,e.amount, trim(s.codename) as codename,s.sale from g_spdm s left join g_spdmdetail d on s.code=d.code left join colortbl c on d.colorid=c.colorid left join g_endstore e on e.shopid='Y52000' and s.code=e.code and d.colorid=e.colorid where s.code='1CRC1821781' or s.code in (select code from g_spdm where c_specialbh=(select c_specialbh from g_spdm where code='1CRC1821781' and coalesce(c_specialbh,'')&lt;&gt;'')) order by code,colorid,xsize limit 100 <img src="https://www.showdoc.cc/home/common/visitfile/sign/8650bda73d2bb45ea21a7abeef30aa35?showdoc=.jpg" alt="" /></p> <p>解决办法 找到zmdserver/pose_kccx.php中 找到相关sql代码 那直接把红框中 or 后面的条件删除了</p> <p><img src="https://www.showdoc.cc/home/common/visitfile/sign/dc6073a9e4f4a1055428dc938f306344?showdoc=.jpg" alt="" /></p>