一种方法是通过在 where 子句中使用子选择来过滤您的选择。我这样做的速度非常快,只是为了演示:
select * from manufacturer m
inner join manufacturer_has_product mhp
on m.manufacturer_id = m.manufacturer_id
inner join product p
on mhp.product_id = p.product_id
where m.manufacturer_id in (
select m.manufacturer_id
from manufacturer m
inner join manufacturer_has_product mhp
on m.manufacturer_id = m.manufacturer_id
inner join product p
on mhp.product_id = p.product_id
inner join productType_has_product pthp
on pt.product_product_id = p.product_id
inner join productType pt
on pt.productType_type_id = pt.type_id
group by m.manufacturer_id
having count(pt.type_id) > 1
)
本文收集自互联网,转载请注明来源。
如有侵权,请联系[email protected] 删除。
我来说两句