Changes between Version 15 and Version 16 of ImportantUseCase0

Timestamp:

02/05/24 16:00:40 (8 months ago)

Author:

201171

Comment:

--

ImportantUseCase0

@@ -93 +93 @@
 [[Image(9-1.jpg)]]
 
+{{{
+select order_table.order_id,
+order_table.order_date,
+product.product_image,
+product.product_name,
+order_table_contains_product.quantity,
+order_table.order_status
+
+from order_table
+join order_table_contains_product on order_table_contains_product.order_id = order_table.order_id
+join product on product.product_id = order_table_contains_product.product_id
+
+where order_table.customer_id = 8
+}}}