SELECT * FROM Addenda_Nodo WHERE An_Padre = '0117' AND Ad_Cve_Addenda = '0004' ORDER BY An_ID ASC SELECT * FROM Addenda_Nodo_Campo WHERE Ad_Cve_Addenda = '0004' AND An_ID = '0117' ORDER BY Anc_ID ASC SELECT * FROM Addenda_Nodo WHERE An_Padre = '0116' AND Ad_Cve_Addenda = '0004' ORDER BY An_ID ASC SELECT * FROM Addenda_Nodo_Campo WHERE Ad_Cve_Addenda = '0004' AND An_ID = '0116' ORDER BY Anc_ID ASC SELECT * FROM Addenda_Nodo WHERE An_Padre = '0115' AND Ad_Cve_Addenda = '0004' ORDER BY An_ID ASC SELECT * FROM Addenda_Nodo_Campo WHERE Ad_Cve_Addenda = '0004' AND An_ID = '0115' ORDER BY Anc_ID ASC SELECT * FROM Addenda_Nodo WHERE An_Padre = '0114' AND Ad_Cve_Addenda = '0004' ORDER BY An_ID ASC SELECT * FROM Addenda_Nodo_Campo WHERE Ad_Cve_Addenda = '0004' AND An_ID = '0114' ORDER BY Anc_ID ASC SELECT * FROM Addenda_Nodo WHERE An_Padre = '0113' AND Ad_Cve_Addenda = '0004' ORDER BY An_ID ASC SELECT * FROM Addenda_Nodo_Campo WHERE Ad_Cve_Addenda = '0004' AND An_ID = '0113' ORDER BY Anc_ID ASC SELECT * FROM Addenda_Nodo WHERE An_Padre = '0112' AND Ad_Cve_Addenda = '0004' ORDER BY An_ID ASC SELECT * FROM Addenda_Nodo_Campo WHERE Ad_Cve_Addenda = '0004' AND An_ID = '0112' ORDER BY Anc_ID ASC SELECT * FROM Addenda_Nodo WHERE An_Padre = '0111' AND Ad_Cve_Addenda = '0004' ORDER BY An_ID ASC SELECT * FROM Addenda_Nodo_Campo WHERE Ad_Cve_Addenda = '0004' AND An_ID = '0111' ORDER BY Anc_ID ASC SELECT * FROM Addenda_Nodo WHERE An_Padre = '0110' AND Ad_Cve_Addenda = '0004' ORDER BY An_ID ASC SELECT * FROM Addenda_Nodo_Campo WHERE Ad_Cve_Addenda = '0004' AND An_ID = '0110' ORDER BY Anc_ID ASC SELECT * FROM Addenda_Nodo WHERE An_Padre = '0109' AND Ad_Cve_Addenda = '0004' ORDER BY An_ID ASC SELECT * FROM Addenda_Nodo_Campo WHERE Ad_Cve_Addenda = '0004' AND An_ID = '0109' ORDER BY Anc_ID ASC SELECT * FROM Addenda_Nodo WHERE An_Padre = '0108' AND Ad_Cve_Addenda = '0004' ORDER BY An_ID ASC SELECT * FROM Addenda_Nodo_Campo WHERE Ad_Cve_Addenda = '0004' AND An_ID = '0108' ORDER BY Anc_ID ASC SELECT * FROM Addenda_Nodo WHERE An_Padre = '0107' AND Ad_Cve_Addenda = '0004' ORDER BY An_ID ASC SELECT * FROM Addenda_Nodo_Campo WHERE Ad_Cve_Addenda = '0004' AND An_ID = '0107' ORDER BY Anc_ID ASC SELECT * FROM Addenda_Nodo WHERE An_Padre = '0106' AND Ad_Cve_Addenda = '0004' ORDER BY An_ID ASC SELECT * FROM Addenda_Nodo_Campo WHERE Ad_Cve_Addenda = '0004' AND An_ID = '0106' ORDER BY Anc_ID ASC SELECT * FROM Addenda_Nodo WHERE An_Padre = '0105' AND Ad_Cve_Addenda = '0004' ORDER BY An_ID ASC SELECT * FROM Addenda_Nodo_Campo WHERE Ad_Cve_Addenda = '0004' AND An_ID = '0105' ORDER BY Anc_ID ASC SELECT * FROM Addenda_Nodo WHERE An_Padre = '0104' AND Ad_Cve_Addenda = '0004' ORDER BY An_ID ASC SELECT * FROM Addenda_Nodo_Campo WHERE Ad_Cve_Addenda = '0004' AND An_ID = '0104' ORDER BY Anc_ID ASC SELECT * FROM Addenda_Nodo WHERE An_Padre = '0103' AND Ad_Cve_Addenda = '0004' ORDER BY An_ID ASC SELECT * FROM Addenda_Nodo_Campo WHERE Ad_Cve_Addenda = '0004' AND An_ID = '0103' ORDER BY Anc_ID ASC SELECT * FROM Addenda_Nodo WHERE An_Padre = '0102' AND Ad_Cve_Addenda = '0004' ORDER BY An_ID ASC SELECT * FROM Addenda_Nodo_Campo WHERE Ad_Cve_Addenda = '0004' AND An_ID = '0102' ORDER BY Anc_ID ASC SELECT * FROM Addenda_Nodo WHERE An_Padre = '0101' AND Ad_Cve_Addenda = '0004' ORDER BY An_ID ASC SELECT * FROM Addenda_Nodo_Campo WHERE Ad_Cve_Addenda = '0004' AND An_ID = '0101' ORDER BY Anc_ID ASC SELECT * FROM Addenda_Nodo WHERE An_Padre = '0100' AND Ad_Cve_Addenda = '0004' ORDER BY An_ID ASC SELECT * FROM Addenda_Nodo_Campo WHERE Ad_Cve_Addenda = '0004' AND An_ID = '0100' ORDER BY Anc_ID ASC SELECT * FROM Addenda_Nodo WHERE An_Padre = '0099' AND Ad_Cve_Addenda = '0004' ORDER BY An_ID ASC SELECT * FROM Addenda_Nodo_Campo WHERE Ad_Cve_Addenda = '0004' AND An_ID = '0099' ORDER BY Anc_ID ASC SELECT * FROM Addenda_Nodo WHERE An_Padre = '0098' AND Ad_Cve_Addenda = '0004' ORDER BY An_ID ASC SELECT * FROM Addenda_Nodo_Campo WHERE Ad_Cve_Addenda = '0004' AND An_ID = '0098' ORDER BY Anc_ID ASC SELECT * FROM Addenda_Nodo WHERE An_Padre = '0097' AND Ad_Cve_Addenda = '0004' ORDER BY An_ID ASC SELECT * FROM Addenda_Nodo_Campo WHERE Ad_Cve_Addenda = '0004' AND An_ID = '0097' ORDER BY Anc_ID ASC SELECT * FROM Addenda_Nodo WHERE An_Padre = '0096' AND Ad_Cve_Addenda = '0004' ORDER BY An_ID ASC SELECT * FROM Addenda_Nodo_Campo WHERE Ad_Cve_Addenda = '0004' AND An_ID = '0096' ORDER BY Anc_ID ASC SELECT * FROM Addenda_Nodo WHERE An_Padre = '0095' AND Ad_Cve_Addenda = '0004' ORDER BY An_ID ASC SELECT * FROM Addenda_Nodo_Campo WHERE Ad_Cve_Addenda = '0004' AND An_ID = '0095' ORDER BY Anc_ID ASC SELECT * FROM Addenda_Nodo WHERE An_Padre = '0094' AND Ad_Cve_Addenda = '0004' ORDER BY An_ID ASC SELECT * FROM Addenda_Nodo_Campo WHERE Ad_Cve_Addenda = '0004' AND An_ID = '0094' ORDER BY Anc_ID ASC SELECT CAST( FACTURA.FC_ID AS INTEGER ) AS ID_FACTURA, PRODUCTO.PR_DESCRIPCION AS PRODUCTO_DESCRIPCION, PRODUCTO.PR_CVE_PRODUCTO AS CLAVE_PRODUCTO, FACTURA.FC_CANTIDAD_1 AS PRODUCTO_CANTIDAD, CASE FACTURA.FC_UNIDAD_1 WHEN 'PZ' THEN 'PZA' WHEN 'CJ' THEN 'CAJ' WHEN 'KG' THEN 'KG' ELSE 'PZA' END AS PRODUCTO_UNIDAD, FACTURA.FC_PRECIO_DESCONTADO AS PRODUCTO_PRECIODESCONTADO, FACTURA.FC_PRECIO_DESCONTADO_IMPORTE AS PRODUCTO_DESCONTADOIMPORTEFROM FACTURA FACTURA INNER JOIN PRODUCTO PRODUCTO ON FACTURA.PR_CVE_PRODUCTO = PRODUCTO.PR_CVE_PRODUCTO INNER JOIN CLIENTE CLIENTE ON FACTURA.CL_CVE_CLIENTE = CLIENTE.CL_CVE_CLIENTEWHERE FACTURA.FC_FOLIO = '01-0025549' SELECT * FROM Addenda_Nodo WHERE An_Padre = '0093' AND Ad_Cve_Addenda = '0004' ORDER BY An_ID ASC