Revision 569b0caf
Von Philip Reetz vor fast 18 Jahren hinzugefügt
| SL/DN.pm | ||
|---|---|---|
|
$query =
|
||
|
qq|SELECT
|
||
|
c.id AS customer_id, c.name, c.street, c.zipcode, c.city,
|
||
|
c.country, c.department_1, c.department_2, c.email
|
||
|
c.country, c.department_1, c.department_2, c.email, c.customernumber
|
||
|
FROM dunning d
|
||
|
LEFT JOIN ar ON (d.trans_id = ar.id)
|
||
|
LEFT JOIN customer c ON (ar.customer_id = c.id)
|
||
Auch abrufbar als: Unified diff
Beim Drucken von Mahnungen stand die Kundennummer nicht zur Verfuegung