Changes between Version 36 and Version 37 of UseCaseModel/AddingShipment

Timestamp:

01/16/25 11:14:02 (6 days ago)

Author:

153093

Comment:

--

UseCaseModel/AddingShipment

@@ -25 +25 @@
     ) as Customers,
     CONCAT(e.employee_name, ' ', e.employee_surname) AS EmployeeFullName,
-    CONCAT(v.make, ' ', v.model, ' (', v.registration, ')') AS VehicleInfo
+    CONCAT(vd.make, ' ', vd.model, ' (', v.registration, ')') AS VehicleInfo
 FROM shipment s
 JOIN employee e ON s.employee_id = e.employee_id
 JOIN vehicle v ON s.vehicle_id = v.vehicle_id
+join vehicle_details vd on vd.vehicle_details_id = v.vehicle_details_id 
 ORDER BY s.shipment_date desc";
 }}}