Answered step by step
Verified Expert Solution
Question
1 Approved Answer
List of names of suppliers offering both computers and oranges. Tb_Offers: Supp_ID | Prod_ID | Price | Quantity | Tb_Product: Prod_ID | Name | MU
List of names of suppliers offering both computers and oranges.
Tb_Offers:
Supp_ID | Prod_ID | Price | Quantity |
Tb_Product:
Prod_ID | Name | MU |
Tb_Supplier:
Supp_ID | Name | City |
--Below is what I have, but I am doing something wrong because the desired output is not being produced. Thanks for any help given.
SELECT DISTINCT Tb_Supplier.Name FROM Tb_Supplier, TB_Offers, Tb_Product WHERE Tb_Supplier.Supp_ID=TB_Offers.Supp_ID AND Tb_Product.Prod_ID=TB_Offers.Prod_ID AND (Tb_Product.Name = 'Computer' OR Tb_Product.Name = 'Oranges')
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started