Tanuj Kumar Total Post:134 Points:940 Posted by Tanuj Kumar April-03-2013 2:39 AM MSSQL Server MSSQL Server 1 Reply(s) 1435 View(s) Ratings: Rate this: Hi Everyone! 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!