D
Devlin
Table: Stores
StoreID
StoreName
StoreInfo
Table: Products
ProductID
ProductName
Table: StoreProducts
SP_ID
SP_R_StoreID
SP_R_ProductID
Question: Need a query that will look up the store that sells 5 particular
products and nothing else from the table StoreProducts. Can this be done in
a simple SELECT query? If not what kind of query will work for this scenario?
StoreID
StoreName
StoreInfo
Table: Products
ProductID
ProductName
Table: StoreProducts
SP_ID
SP_R_StoreID
SP_R_ProductID
Question: Need a query that will look up the store that sells 5 particular
products and nothing else from the table StoreProducts. Can this be done in
a simple SELECT query? If not what kind of query will work for this scenario?