There is a PRODUCT table

 PRODUCT_ID NAME 01 Товар 1 02 Товар 2 03 Товар 3

There is a table SHOPS

 SHOPS_ID NAME 01 Магазин 1 02 Магазин 2 03 Магазин 3

There is a table that binds them PRODUCT_TO_SHOPS

 PRODUCT_ID SHOPS_ID 01 01 01 02 02 03 03 01 03 02 03 03

Products may apply to several stores at once.

Tell me, please, how to make a request to get products that relate only to the specified / specified store.

For example:

1) SHOPS_ID = 03, issued Item 2, Item 3

2) SHOPS_ID = 01 and 02 issued Item 1, Item 3

  • Can you read the basics of sql or something? - nick_n_a

1 answer 1

You have something all kapslok, unreadable, but whatever it was:

 SELECT PRODUCT.NAME FROM PRODUCT_TO_SHOPS JOIN SHOPS ON SHOPS.SHOPS_ID = PRODUCT_TO_SHOPS.SHOPS_ID JOIN PRODUCT ON PRODUCT.PRODUCT_ID = PRODUCT_TO_SHOPS.PRODUCT_ID WHERE PRODUCT_TO_SHOPS.SHOPS_ID IN (ид_магазинов_через_запятую) GROUP BY PRODUCT_TO_SHOPS.PRODUCT_ID

True, you can do without JOIN SHOPS , but if you need data from all the tables, then so.