select a.products_id from(select * from products_attributes group by products_id) as a ,(select products_id from products_attributes where options_values_id=11 group by products_id) as bwhere a.products_id<>b.products_id查询不不包含options_values_id=11的所有products_id表里有多张数据 并且相同的products_id多条查出两张临时表分组比较 两张临时表查询是对的 a条数为7860 b为5470但最后查询出来的条数有42988730 不科学啊。。原表是有多个字段的 然后我新建只包含查询的字段的表查询是没问题的
你的已经笛卡尔积了！这个查询sql有问题
select a.products_id from(select * from products_attributes group by products_id) as a ,(select products_id from products_attributes where options_values_id=11 group by products_id) as b where a.products_id<>b.products_id 看你的条件 把匹配上的过滤掉 没匹配的显示出来了