Cacher is the code snippet organizer for pro developers

---
---Pedidos facturados
---
select a.* from tbldoc a with (nolock) 
join tblterceros c with (nolock) on a.strCodCA = c.strCodigo
join tblzonas d with (nolock) on c.strCodigoZona = d.strCodigo and a.strCamGen = '201908' and d.STRMAILGROUP = 'G' and a.strTipDoc = 'FC'