select * from NotaFiscalC_tb where NroNotaFiscal_nfc = 2704

select * from NotaFiscalC_tb where Codigo_nfc = 2698

select * from NotaFiscalRef_tb where RefECFCOO_nfr = RefECFCOO_nfr and
Codigo_nfc = 2698

select * from NotaFiscalRef_tb where RefECFCOO_nfr = 35059


SELECT RefECFNumeroOrdemECF_nfr, RefECFCOO_nfr 
  from NotaFiscalRef_tb where Codigo_nfc = 2698
  group by RefECFNumeroOrdemECF_nfr, RefECFCOO_nfr
having count(*) > 1  order by RefECFCOO_nfr