salix/print/templates/reports/incoterms-authorization/sql/company.sql

9 lines
167 B
MySQL
Raw Permalink Normal View History

2023-10-03 08:15:16 +00:00
SELECT
2022-06-13 09:03:11 +00:00
s.name,
s.city,
cl.name AS manager
FROM company c
JOIN supplier s ON s.id = c.id
JOIN client cl ON cl.id = c.workerManagerFk
2023-10-03 08:15:16 +00:00
WHERE c.id = ?