printnatura/sql/jobData.sql

8 lines
192 B
SQL

SELECT pq.workerFk userFk,
r.name report,
p.name printer,
r.method
FROM printQueue pq
JOIN report r ON r.id = pq.reportFk
LEFT JOIN printer p ON p.id = pq.printerFk
WHERE pq.id = ?