How to link data from one SQL table?

Question

Database design

There is 1 table with products, each product can be sold separately, or together with other well-defined products from the same table . The decision comes to mind to create a second table where for each product to indicate the id of other products with which it can be sold, but this solution looks rather cumbersome. What do you advise?

Answer 1

The decision comes to mind to create a second table where for each product indicate the id of other products with which it can be sold

Comes right. This standard solution is a link table for a many-to-many relationship.