mmesa
5/30/2019 - 2:42 PM

Mas de una factura en campaña

---
---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