Sql Query to list cuisines

Asked Apr 23 '22 at 16:20

Active Apr 23 '22 at 16:40

Viewed 68 times

Ingredient (iID, iname, madeIn)
Dish (dID, dname, cuisine, vegetarian, introduction)
Recipe (dID, iID, usageDec)

List the dID, dname of the dish(s) that use all 3 ingredients (“Ginger”, “Onion” and “Garlic”) in its recipe. In descending order of dID, remove duplicates.

I have given my code below. Not getting the right output. Help me out please.

SELECT Distinct d.dID, D.dname
FROM Dish D, Ingredient I, Recipe R 
WHERE D.dID=R.dID AND 
I.iname="Garlic" AND
I.iname="Ginger" AND
I.iname="Onion"
ORDER BY D.dID DESC;

asked Apr 23 '22 at 16:20

Xian Li

1

Hint: Use SQL JOIN – Anindya Dey Apr 23 '22 at 16:23
Could you correct my code and tell me the changes – Xian Li Apr 23 '22 at 16:24
Please povide sample data and desired result – Slava Rozhnev Apr 23 '22 at 16:38
SELECT Distinct d.dID, D.dname FROM Dish D JOIN Recipe R ON D.dID=R.dID JOIN Ingredient I ON R.iID=I.iID WHERE I.iname="Garlic" AND I.iname="Ginger" AND I.iname="Onion" ORDER BY D.dID DESC; Rewritten to preferred JOINs-style.But wen need some sample data to write the correct query – Sergey Apr 23 '22 at 16:39

Sql Query to list cuisines

0 Answers0