I have 2 tables.
SKUs
SkuRestrictions
Skus are products and SkuRestrictions are restrictions on a product.
A Sku can have multiple Sku Restrictions.
I need my query to remove the records of Skus with the SkuRestrictionsID of 3,4,5,13,16, or 18
Now my query does a good job of removing the exact records with these exact SkuRestrictionsID
BUT.....
Lets say a SkuID of 3381 has SkuRestrictionsID of 2 , 5 ,16 , and 20
The 5 and 16 will be removed but I need all of them removed from the results of SkuID 3381
How can I do this??? Thanks!
Lets say a SkuID of 3381 has SkuRestrictionsID of 2 and that same 3381 also has a SkuRestrictionsID of 5
and I want SkuRestrictionsID of 5 removed. Then that means I want 3381 completely removed from the SKUs result query. NO 3381 at all NATTA! NUN!
With the way I am doing it. Which is what you said....
The results come back back with
SkuID| SkuRestrictionsID
--------------------------
3529| 10
3659|17
3381| 2 Get this out of here!
I understand it did as I said remove
SkuID| SkuRestrictionsID
--------------------------
3381| 5
But not 2!
I have to remove all records pertaining to 3381.
I hope this makes sense. Think of it like this. If you had rules to go by and a product fell under one of the restrictions then that product isn't allow. This is why each SKU has multiple SkuRestrictions because it can be restricted in several ways.
Like Used, Overweight, Food Etc... So I have to figure out a way to remove it (3381) completely from my query if it falls under even 1 of them restrictions (SkuRestrictions)
Thank you!