select *
from documento
inner join receptorcfdi on receptorcfdi.id = documento.receptorCfdiId
where FechaRecepcion >= '01-01-2019'
select sum(Total),RFC
from documento
inner join Emisor on emisor.id = documento.EmisorId
where FechaRecepcion >= '01-01-2019'
group by RFC
select *
from documento
inner join receptorcfdi on receptorcfdi.id = documento.receptorCfdiId
where FechaRecepcion >= '01-01-2019';
select sum(Total),RFC
from documento
inner join Emisor on emisor.id = documento.EmisorId
where FechaRecepcion >= '01-01-2019'
group by RFC
;
No hay comentarios
https://www.programacionparatodos.com/2019/06/programasql.html