Fórum Ola, pessoal poque esse comando na retorna correto? #564606

select distinct it.status as iv_status, nf.data, nf.seqnf, nf.especienf, nf.status as nf_status, li.status as liv_status, li.especie
from itensnotasfiscais it
inner join notasfiscais nf on nf.id= it.id
inner join livrosai li on li.idnota = it.id
where nf.especienf='NFC' and li.especie='NFC'
and nf.data between '01.03.2016' and '30.03.2016'
group by it.status, nf.data, nf.seqnf, nf.especienf, nf.status,  li.status, li.especie
order by nf.seqnf