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