13.04.2018 13:30, acgomes2...@yahoo.com.br wrote: > > select N.DTEMISSAONOTA as DATA, > 'DINHEIRO' as MEIO_PAGAMENTO1, > cast('DINHEIRO' as char(10)) as MEIO_PAGAMENTO2, > '000000' as MEIO_PAGAMENTO, > N.VLRTOTALNOTA as VALOR, > 0 as AUTENT_01, > 0 as AUTENT_01_CALC, > N.AUTENTICACAO_NOTA as AUTENT_02, > 3 as TIPO > from NOTA N > where (N.EMPRESANOTA = 1) > and (N.DTEMISSAONOTA between '05/11/2018' and '04/11/2018') > and (N.MODELONOTA = '55') > order by 1, 2
http://tracker.firebirdsql.org/browse/CORE-5743 Dmitry