Revision 7eae8fac
Von Moritz Bunkus vor mehr als 17 Jahren hinzugefügt
SL/IS.pm | ||
---|---|---|
1370 | 1370 |
|
1371 | 1371 |
$query = |
1372 | 1372 |
qq|SELECT |
1373 |
(SELECT c.accno FROM chart c |
|
1374 |
WHERE d.inventory_accno_id = c.id) AS inventory_accno, |
|
1375 |
(SELECT c.accno FROM chart c |
|
1376 |
WHERE d.income_accno_id = c.id) AS income_accno, |
|
1377 |
(SELECT c.accno FROM chart c |
|
1378 |
WHERE d.expense_accno_id = c.id) AS expense_accno, |
|
1379 |
(SELECT c.accno FROM chart c |
|
1380 |
WHERE d.fxgain_accno_id = c.id) AS fxgain_accno, |
|
1381 |
(SELECT c.accno FROM chart c |
|
1382 |
WHERE d.fxloss_accno_id = c.id) AS fxloss_accno, |
|
1373 |
(SELECT c.accno FROM chart c WHERE d.inventory_accno_id = c.id) AS inventory_accno, |
|
1374 |
(SELECT c.accno FROM chart c WHERE d.income_accno_id = c.id) AS income_accno, |
|
1375 |
(SELECT c.accno FROM chart c WHERE d.expense_accno_id = c.id) AS expense_accno, |
|
1376 |
(SELECT c.accno FROM chart c WHERE d.fxgain_accno_id = c.id) AS fxgain_accno, |
|
1377 |
(SELECT c.accno FROM chart c WHERE d.fxloss_accno_id = c.id) AS fxloss_accno, |
|
1383 | 1378 |
d.curr AS currencies |
1384 | 1379 |
${query_transdate} |
1385 | 1380 |
FROM defaults d|; |
Auch abrufbar als: Unified diff
Kosmetik.