SQL-çàïðîñ: êàê ÏÐÀÂÈËÜÍÎ íàïèñàòü çàïðîñ ñ äàòîé? |
SELECT ÔÍ.Çàâíîìåð, ÔÍ.ÄîÊàêîéÄàòûÄåéñòâóåò, ÔÍ.ÄàòàÓñòàíîâêè, ÔÍ.Ïðèìå÷àíèå, ôð.çàâíîìåð, ôð.IPàäðåñ, ìàãàçèíû.íîìåð, ìàãàçèíû.Íàçâàíèå, ÔÍ.ÄîÊàêîéÄàòûÄåéñòâóåò FROM ìàãàçèíû INNER JOIN (ôð INNER JOIN ÔÍ ON ôð.Êîä = ÔÍ.ÍàÊàêîìÔðÑòîèò) ON ìàãàçèíû.Êîä = ôð.âÊàêîìÌàãàçèíå WHERE IsNull ( [ÔÍ].[ÄàòàÑíÿëèÔÍ] )<>False AND ÔÍ.ÄîÊàêîéÄàòûÄåéñòâóåò <#01.01.2020#;
https://www.sql.ru/forum/1310759/sql-zapros-kak-pravilno-napisat-zapros-s-datoy
| Êîììåíòèðîâàòü | « Ïðåä. çàïèñü — Ê äíåâíèêó — Ñëåä. çàïèñü » | Ñòðàíèöû: [1] [Íîâûå] |