запросы_к_регистрам
Различия
Показаны различия между двумя версиями страницы.
| Предыдущая версия справа и слеваПредыдущая версия | |||
| запросы_к_регистрам [2019/09/03 06:27] – timofeev | запросы_к_регистрам [2019/09/03 06: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< | + | FROM R_SKK WHERE TARA=1000000000001 AND ADRES=1000000000001 AND DATADOC< |
| 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< | + | FROM R_ZAL WHERE TARA=1000000000001 AND ADRES=1000000000001 AND DATADOC< |
| '' | '' | ||
запросы_к_регистрам.1567492061.txt.gz · Последнее изменение: — timofeev