запросы_к_регистрам
Различия
Здесь показаны различия между двумя версиями данной страницы.
| Предыдущая версия справа и слева Предыдущая версия | |||
|
запросы_к_регистрам [2019/09/03 09:27] timofeev |
запросы_к_регистрам [2019/09/03 09:30] (текущий) timofeev [Долг по таре клиента] |
||
|---|---|---|---|
| Строка 78: | Строка 78: | ||
| 0 AS OST_, SUM(IIF(P_KOLICHESTVO IS NULL,0, P_KOLICHESTVO))-SUM(IIF(R_KOLICHESTVO IS NULL,0, R_KOLICHESTVO)) AS SOB_, | 0 AS OST_, SUM(IIF(P_KOLICHESTVO IS NULL,0, P_KOLICHESTVO))-SUM(IIF(R_KOLICHESTVO IS NULL,0, R_KOLICHESTVO)) AS SOB_, | ||
| 0 AS ZAL_ | 0 AS ZAL_ | ||
| - | FROM R_SKK WHERE TARA=1000000000001 AND ADRES<>1000000000001 AND DATADOC<='03.09.2019'\\ | + | FROM R_SKK WHERE TARA=1000000000001 AND ADRES=1000000000001 AND DATADOC<='03.09.2019'\\ |
| UNION ALL\\ | UNION ALL\\ | ||
| SELECT 0 AS OST_, 0 AS SOB_, | SELECT 0 AS OST_, 0 AS SOB_, | ||
| SUM(IIF(P_KOLICHESTVO IS NULL,0, P_KOLICHESTVO))-SUM(IIF(R_KOLICHESTVO IS NULL,0, R_KOLICHESTVO)) AS ZAL_ | SUM(IIF(P_KOLICHESTVO IS NULL,0, P_KOLICHESTVO))-SUM(IIF(R_KOLICHESTVO IS NULL,0, R_KOLICHESTVO)) AS ZAL_ | ||
| - | FROM R_ZAL WHERE TARA=1000000000001 AND ADRES<>1000000000001 AND DATADOC<='03.09.2019') | + | FROM R_ZAL WHERE TARA=1000000000001 AND ADRES=1000000000001 AND DATADOC<='03.09.2019') |
| '' | '' | ||
запросы_к_регистрам.1567492061.txt.gz · Последние изменения: 2019/09/03 09:27 — timofeev
Инструменты страницы
