Changes between Version 13 and Version 14 of usefulQueries

Timestamp:

10/28/2019 01:39:34 PM (6 years ago)

Author:

volodya

Comment:

--

usefulQueries

@@ -406 +406 @@
 }}}
 
-}}}
+== [=#point9] Деактивувати постачальників по яким не було жодного приходу ==
+
+{{{
+update t_clients set is_active = 0 where clients_id > 100 and
+    clients_id not in
+(
+select distinct clients_id as id from t_documents where typedoc_id != 11
+union
+select distinct objects_id as id from t_documents where typedoc_id != 11
+ )
+}}}
+
+}}}