salix/print/templates/reports/exportation/sql/invoice.sql

8 lines
144 B
MySQL
Raw Permalink Normal View History

SELECT
io.id,
io.ref,
2022-09-26 11:33:27 +00:00
io.issued,
io.companyFk
FROM invoiceOut io
2022-07-21 08:05:37 +00:00
LEFT JOIN ticket t ON t.refFk = io.ref
WHERE t.refFk = ?