2020-09-25 12:45:00 +00:00
|
|
|
SELECT
|
|
|
|
|
c.street,
|
|
|
|
|
c.socialName,
|
|
|
|
|
c.city,
|
|
|
|
|
c.postcode,
|
|
|
|
|
c.id,
|
|
|
|
|
c.name AS clientName,
|
|
|
|
|
p.name AS province,
|
2024-04-26 08:26:20 +00:00
|
|
|
co.name country
|
2020-09-25 12:45:00 +00:00
|
|
|
FROM client c
|
|
|
|
|
JOIN province p ON c.provinceFk = p.id
|
|
|
|
|
JOIN country co ON c.countryFk = co.id
|
|
|
|
|
WHERE c.id = ?
|
