salix/print/templates/reports/vehicle-event-expired/sql/vehicleEvents.sql

7 lines
148 B
MySQL
Raw Permalink Normal View History

2022-09-21 06:11:04 +00:00
SELECT
v.numberPlate,
ve.description,
ve.finished
FROM vehicleEvent ve
JOIN vehicle v ON v.id = ve.vehicleFk
WHERE ve.id IN (?)