Buenas tardes, tengo estas dos query:
En una las cobranzas relacionadas con las facturas y notas de debito (con las tablas OINV Y ORCT) Y en el otro query las cobranzas con las notas de crédito, como puedo unir ambas tablas?
1)
SELECT T1."DocNum" AS "Nro Recibo", T1."Canceled", T1."TaxDate", T1."DocDueDate", T0."CardCode", T1."CardName", T1."DocTotal" AS "Tot s/ret", T1."U_Total_Documento", (T0."Letter" || LPAD (T0."PTICode", 4, 0) || '-' || LPAD (T0."FolNumFrom", 8, 0)) as "Nro Comprobante", T0."DocCur" AS "Moneda", T0."DocTotalSy" AS "Total",T0."VatSum" AS "IVA", T0."DiscSum" as "Redondeo", T0."WTSum" as "Retención", T0."U_UN", T0."U_CC"
FROM OINV T0 INNER JOIN ORCT T1 ON T0."ReceiptNum" = T1."DocEntry"
WHERE T1."TaxDate" >=[%0] AND T1."TaxDate" <=[%1] AND T1."JrnlMemo" NOT Like '%%Cancelado%%'
SELECT T1."DocNum" AS "Nro Recibo", T1."Canceled", T1."TaxDate", T1."DocDueDate", T0."CardCode", T1."CardName", T1."DocTotal" AS "Tot s/ret", T1."U_Total_Documento", (T0."Letter" || LPAD (T0."PTICode", 4, 0) || '-' || LPAD (T0."FolNumFrom", 8, 0)) as "Nro Comprobante", T0."DocCur" AS "Moneda", T0."DocTotalSy" AS "Total",T0."VatSum" AS "IVA", T0."DiscSum" as "Redondeo", T0."WTSum" as "Retención", T0."U_UN", T0."U_CC" FROM ORIN T0 INNER JOIN ORCT T1 ON T0."ReceiptNum" = T1."DocEntry"
WHERE T1."TaxDate" >=[%0] AND T1."TaxDate" <=[%1] AND T1."JrnlMemo" NOT Like '%%Cancelado%%'
Cualquier duda me avisan.
Muchas gracias, saludos