| Unidad |
Placa |
Modelo |
Ingresos |
Gastos |
Gto % |
Neto |
Rend % |
| |
select UNDNombre, UNDLinea2, MODNombre, SUM(FCTMonto3) as Ingresos, SUM(GASMonto1) as Egresos from 410UND,410MOD,410GAS,410FCT,410CTR where UNDLink1_MOD = MODCodigo AND GASLink1_UND = UNDCodigo AND FCTLink1_CTR = CTRCodigo AND CTRLink1_UND = UNDCodigo AND GASFecha1 AND FCTCheckbox3 = 0 AND GASFecha1 > '--' AND GASFecha1 < '--' AND FCTFecha2 > '--' AND FCTFecha2 < '--'
| |
|
|