Changes between Version 6 and Version 7 of Application Design – Use Cases and Database Access Scenarios – SQL View
- Timestamp:
- 08/27/25 08:30:26 (7 days ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
Application Design – Use Cases and Database Access Scenarios – SQL View
v6 v7 224 224 SELECT 225 225 o.order_id, o.order_date, o.status, r.name AS restaurant_name 226 FROM "ORDERS" o 227 JOIN RESTAURANT r ON o.address_id = r.address_id 228 JOIN RESTAURANT_OWNERS ro ON r.restaurant_id = ro.restaurant_id 226 FROM "ORDERS" o\\ 227 JOIN RESTAURANT r ON o.address_id = r.address_id\\ 228 JOIN RESTAURANT_OWNERS ro ON r.restaurant_id = ro.restaurant_id\\ 229 229 WHERE o.order_id = 1; 230 231 230 }}}