A food delivery system uses the following tables:
Restaurants: (RestaurantID, RestaurantName, City) Dishes: (DishID, DishName, RestaurantID, Price) You want to list all restaurants along with their dishes . If a restaurant has no dishes, it should still be displayed. Which queries will correctly produce the desired result? (select all that apply

Question

A  food delivery system  uses the following tables: 
  Restaurants: (RestaurantID, RestaurantName, City)   Dishes: (DishID, DishName, RestaurantID, Price) You want to  list all restaurants along with their dishes . If a restaurant has no dishes, it should still be displayed. Which queries will correctly produce the desired result? (select all that apply

Accepted Answer

SELECT RestaurantName, DishName  FROM Dishes  RIGHT JOIN  Restaurants ON Dishes.RestaurantID = Restaurants.RestaurantID;

Answer

SELECT RestaurantName, DishName  FROM Dishes  LEFT JOIN  Restaurants ON Restaurants.RestaurantID = Dishes.RestaurantID;

Answer

SELECT RestaurantName, DishName  FROM Dishes  FULL JOIN  Restaurants ON Dishes.RestaurantID = Restaurants.RestaurantID;

Answer

SELECT RestaurantName, DishName  FROM Restaurants   INNER JOIN  Dishes ON Restaurants.RestaurantID = Dishes.RestaurantID;

Crowdly

A food delivery system uses the following tables: Restaurants: (RestaurantI...

Want instant access to all verified answers on eclass.yorku.ca?