Be part of JetBrains PHPverse 2026 on June 9 – a free online event bringing PHP devs worldwide together.

Mqandeel's avatar

How to get all the products related to the user's shop choice

I have three tables

  • product
  • shop
  • shop_product as a pivot table
0 likes
2 replies
vainway 's avatar

try to show your code so we know what we can help you

Mqandeel's avatar

SELECT * from product where shop_product.shop_id in(1,2,3)

Please or to participate in this conversation.