salix/print/templates/reports/letter-debtor/sql/client.sql

13 lines
245 B
MySQL
Raw Permalink Normal View History

2020-09-25 12:45:00 +00:00
SELECT
c.id,
c.socialName,
c.street,
c.postcode,
c.city,
c.fi,
p.name AS province,
ct.country
FROM client c
JOIN country ct ON ct.id = c.countryFk
LEFT JOIN province p ON p.id = c.provinceFk
WHERE c.id = ?