List of names of suppliers offering both computers and oranges. Tb_Offers: Supp_

Question

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')

Explanation / Answer

SELECT DISTINCT Tb_Supplier.Name

FROM Tb_Product JOIN Tb_Offcers ON Tb_Product.Prod_ID = Tb_Offers.Prod_ID

JOIN Tb_Supplier ON Tb_Offers.Supp_ID = Tb_Supplier.Supp_ID

WHERE Tb_Product.Name = 'Computer' AND Tb_Product.Name = 'Oranges'

Related Questions

Navigate

• Browse (All)
• Browse L
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.