I have a system which backlogs products users receive within a box. The whole system is based on these kits we create with products inside.
So I got a Customers and Products which lists everything I have. And I have a Boxes table which has ProductID1, ProductID2, ProductID3 and ProductID4 fields
and CustomerID field to point which customer received which box.
All I want to do is, given a set of products not in the same order (Ex.: ID4, ID2, ID3, ID1) I need to know all customers that hadn't received any products
of this given set.
Is my database bad designed? What would be the best way to do this or how to make the SELECT query
Thanks in advance!