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

10 lines
165 B
MySQL
Raw Permalink Normal View History

2023-10-03 08:15:16 +00:00
SELECT
a.nickname,
a.street,
a.postalCode,
a.city,
p.name province
FROM address a
LEFT JOIN province p ON p.id = a.provinceFk
WHERE a.id = ?