Already the third hour I puzzle how to write the correct request, but nothing leaves.
The task is as follows:
There is a table of cars

auto (автомобили) id | name ------------- 1 | Volvo 2 | Audi 3 | Toyota

There is a table of spare parts

 spare (запчасти) id | name ------------- 1 | Колеса 2 | Двигатель 3 | Руль

There are many to many table for connecting parts and cars

 spare_to_auto auto_id | spare_id ------------------ 1 | 1 1 | 2 1 | 3 2 | 1 2 | 2

You need to get all the cars in which the list of spare parts in spare_to_auto is completely the same.
The parts list is set by the user in the filter. For example, if the user specified in the filter, parts 1 and 2, then the request should return cars 1 and 2, since these two cars have both of these parts.

That's what I got in the end

 SELECT * FROM auto as a INNER JOIN spare_to_auto AS s_to_a ON a.id = s_to_a.auto_id INNER JOIN spare AS s ON s_to_a.spare_id = s.id AND s.id IN ($список_запчастей)

But unfortunately this request does not work correctly.

1 answer 1

 select auto.name from auto, spare_to_auto as s2a1, spare_to_auto as s2a2 where auto.auto_id = s2a1.auto_id and auto.auto_id = s2a2.auto_id and s2a1.spare_id = 1 s2a2.spare_id = 2 order by auto.name

There will be as many synonyms for spare_to_auto (and, accordingly, the conditions on them) as there are elements in the filter list spare_id