Changes between Version 5 and Version 6 of UseCase4

Timestamp:

12/14/22 17:12:37 (2 years ago)

Author:

201068

Comment:

--

UseCase4

@@ -18 +18 @@
 
 [[Image(selected reservation.png)]]
+{{{#!sql
+select quantity, meal_type, price, number_guests, start_date
+from reservation_for_prepared_meal rfpm 
+join prepared_meal pm on
+ rfpm.prepared_meal_id  = pm.prepared_meal_id 
+join meal m on
+ rfpm.meal_id  = pm.meal_id 
+join reservation r on
+ rfpm.reservation_id = r.reservation_id 
+order by start_date;
+}}}