Please help me debug my SQL query.
- by bob09
I have a query:
Select n_portions, dish_name
from food_order, dish
where n_portions=
(select max (n_portions)
FROM food_order);
It's meant to return:
fish pie 3
steak and chips 1
pasta bake 2
stuffed peppers 1
But i get:
Pasta bake 35
Fish pie 35
Steak and chips 35
Stuffed peppers 35
Ham and rice 35
Lamb curry 35
…