---
---Mas de una factura en campaña
---
select * from tbl_faccab where strCamGen = '201908' and strTipDoc = 'fc' and strCodTer in (
select strCodTer from tbl_faccab where strCamGen = '201908' and strtipdoc = 'fc'
group by strCodTer
having count(*) > 1
) order by strCodTer