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

10 lines
167 B
MySQL
Raw Permalink Normal View History

2021-12-13 07:23:44 +00:00
SELECT
c.id,
c.socialName,
c.name,
c.fi,
c.street,
2024-04-26 08:26:20 +00:00
cty.name country
2021-12-13 07:23:44 +00:00
FROM client c
JOIN country cty ON cty.id = c.countryFk
WHERE c.id = ?