Changes between Version 1 and Version 2 of ImportatntUseCase005

Timestamp:

02/10/25 11:45:26 (12 days ago)

Author:

221164

Comment:

--

ImportatntUseCase005

@@ -37 +37 @@
 }}}
 {{{
+CREATE VIEW order_details_view AS
 SELECT 
     o.id AS order_id,
@@ -55 +56 @@
 JOIN order_items oi ON o.id = oi.order_id
 JOIN products p ON oi.product_id = p.id
-LEFT JOIN payments pm ON o.id = pm.order_id
-WHERE o.id = 4;
+LEFT JOIN payments pm ON o.id = pm.order_id;
+
+SELECT * FROM order_details_view WHERE order_id = 4;
 
 UPDATE orders SET status='CONFIRMED' WHERE id=4;