SQL query to display all orders with a specific set of products?

Question

Transact SQL

MS SQL server
Table with products and order numbers to which they belong

. It is necessary to get only orders highlighted in yellow by a query

Answer 1

SELECT Таблица_1.[ID заказа]
  FROM Таблица AS Таблица_1 
    INNER JOIN Таблица AS Таблица_2 ON Таблица_1.[ID заказа] = Таблица_2.[ID заказа]
  WHERE (Таблица_1.[ID товара] = 'Товар 1') AND (Таблица_2.[ID товара] = 'Товар 2')

There was already a question about garages, where there are all three brands of cars, there were respectively three aliases for the filter.