Различия

Здесь показаны различия между двумя версиями данной страницы.

--- запросы_к_регистрам [2019/09/03 09:27]
timofeev
+++ запросы_к_регистрам [2019/09/03 09:30] (текущий)
timofeev [Долг по таре клиента]
@@ Строка 73: / Строка 73: @@
 ''SELECT SUM(OST_-SOB_-ZAL_) FROM
-(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<='03.09.2019'\\
-AS SOB_, 0 AS ZAL_
+UNION ALL\\
-FROM R_VKK WHERE TARA=1000000000001 AND ADRES=1000000000001 AND DATADOC<='03.09.2019'
-UNION ALL
 SELECT
 AS OST_, SUM(IIF(P_KOLICHESTVO IS NULL,0, P_KOLICHESTVO))-SUM(IIF(R_KOLICHESTVO IS NULL,0, R_KOLICHESTVO)) AS SOB_,
 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_,
 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')
 ''

Водяной