Getting syntax error in teradata sql query missing keyword between var and 'NOT'

join shbcf.ru