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