|
checa esta, la cual funciona a la perfeccion
SELECT NOMBRE,CLIENTE,FOLIO,PAGO,REFERENCIA,TIPO,FECHA,CARGO,ABONO,PRIOR FROM
(SELECT CLIENTE,'N/A' AS FOLIO,'N/A' AS PAGO,'N/A' AS REFERENCIA,'SALDO INICIAL' AS TIPO,FECHA,CARGO,ABONO, 0 AS PRIOR
FROM SALDOCLIENTE
UNION
SELECT CLIENTE,FOLIO,' N/A' AS PAGO,'N/A' AS REFERENCIA,'NOTA DE VENTA' AS TIPO,FECHA,-TOTAL AS CARGO,0 AS ABONO, 2 AS PRIOR
FROM NVENTA WHERE TIPOPAGO=3
UNION
SELECT CLIENTE,FOLIO,' N/A' AS PAGO,'N/A' AS REFERENCIA,'FACTURA' AS TIPO,FECHA,-TOTAL AS CARGO,0 AS ABONO, 1 AS PRIOR
FROM FACTURA WHERE TIPOPAGO=3
UNION
SELECT Cliente, Folio, FolioPago AS PAGO,REF AS REFERENCIA,'PAGO NOTA' AS TIPO, PagoNV.Fecha, 0 AS CARGO,Monto AS ABONO, 2 AS PRIOR
FROM NVenta ,PagoNV
WHERE NVenta.Folio=PagoNV.FolioNV
UNION
SELECT Cliente, Folio, FolioPago AS PAGO,REF AS REFERENCIA,'PAGO FACTURA' AS TIPO, PagoFac.Fecha, 0 AS CARGO,Monto AS ABONO, 1 AS PRIOR
FROM Factura ,PagoFac
WHERE Factura.Folio=PagoFac.FolioFac
UNION
SELECT Cliente, Folio, 'N/A' as PAGO,'N/A' AS REFERENCIA,'NOTA DE CREDITO' AS TIPO, Fecha, 0 AS Cargo, Total AS ABONO, 3 AS PRIOR
FROM NCred) ESTADO, CLIENTE
WHERE (ESTADO.CLIENTE=CLIENTE.CLAVE_C)
ORDER BY Nombre,Prior,Folio,Tipo,Fecha,Pago
|