Please, help with the SQL query creating.
I have a product list with some relationships that are not reflected in any table/db. E.g., the Main group of products 1110, 1111, 1114,
1117, … and some Parts 1119, 1120, 1121, 1122. The product from the Main group can go with any combinations of products from the Parts group.
I need to look at all sales that include some product from the main group with any combination of parts. Actually, the most likely it’s
the one product from the Main group and a one, two, three or four products from the Parts group. So, it can be a combination of a one product from the Main group and from none to four ones from the Part group. If it’s only products from the Main group
without Parts we skip this data or if it’s only Parts without products from the Main group we skip this data too.
The sales table looks as follows:
View Complete Post