Changes between Version 4 and Version 5 of UseCase4

Timestamp:

02/10/25 01:05:23 (13 days ago)

Author:

215010

Comment:

--

UseCase4

@@ -14 +14 @@
 7. Клиентот добива повратен одговор за состојбата (status) на резервацијата.
 
+{{{
+SELECT r.reservation_id, r.start_date, r.end_date, r.status, c.first_name, c.last_name
+FROM Reservation r
+JOIN Customer c ON r.customer_id = c.user_id
+WHERE r.status = 'Pending';
+
+UPDATE Reservation
+SET status = 'Approved'
+WHERE reservation_id = 3;
+}}}