Revision 71dab322
Von Moritz Bunkus vor mehr als 9 Jahren hinzugefügt
| SL/SEPA.pm | ||
|---|---|---|
| 370 | 370 |
(SELECT SUM(sei.amount) |
| 371 | 371 |
FROM sepa_export_items sei |
| 372 | 372 |
WHERE (sei.sepa_export_id = se.id)) AS sum_amounts, |
| 373 |
(SELECT string_agg(semi.message_id, ', ') |
|
| 374 |
FROM sepa_export_message_ids semi |
|
| 375 |
WHERE semi.sepa_export_id = se.id) AS message_ids, |
|
| 373 | 376 |
e.name AS employee |
| 374 | 377 |
FROM sepa_export se |
| 375 | 378 |
LEFT JOIN ( |
Auch abrufbar als: Unified diff
SEPA-Suche: Nachrichten-IDs als Spalte anzeigen