Background - company sells products nationally. requirement is to limit products to whole country, to certain states, or to certain cities. Products may have multiple limits, so it may be available to all of the state of North Carolina and to Boston, Mass (but no other city in Mass.). Stumped on ideas for design of table to hold this and how to join products to it.
TblProducts (ProductID int, ProductName VarChar(100))
TblFilter (ProductID int, State Char(2), City VarChar(250))
with a table setup like that, what kind of query would return all the products if you knew the state and city? Is there a better table design?