Buen dia Estimados,
Necesito me ayuden con un problema en esta consulta la cual me esta dando dolores de cabeza, bien les explico.
Necesito extraer de esta consulta todas las facturas excepto las que tengan aplicada una nota de crédito con la serie 97.
SELECT
t1."DocEntry",t1."DocNum", t2."DocDueDate",t3."City", t3."LicTradNum", t1."CardName", t1."Address2", t3."Phone1", t3."E_Mail", t4."Name", t5."SlpName", t6."GroupName", t7."WhsName", t10."ItmsGrpNam", t9."ItemCode", t0."Dscription", t0."Quantity", t0."DiscPrcnt", t0."TotalSumSy",t12."Rate", t11."PymntGroup", t1."Series" , t1."CANCELED" , t1."Comments"
FROM
INV1 t0 inner join OINV t1 on t0."DocEntry"=t1."DocEntry" left join ODLN t2 on t0."BaseEntry"=t2."DocEntry" left join OCRD t3 on t3."CardCode"=t2."CardCode" left join OCPR t4 on t1."CntctCode"=t4."CntctCode" left join OSLP t5 on t1."SlpCode"=t5."SlpCode" left join OCRG t6 on t3."GroupCode"=t6."GroupCode" left join OWHS t7 on t0."WhsCode"=t7."WhsCode" left join OITM t9 on t0."ItemCode"=t9."ItemCode" left join OITB t10 on t9."ItmsGrpCod"=t10."ItmsGrpCod" left join OCTG t11 on t1."GroupNum"=t11."GroupNum" left join OSTA t12 on t0."TaxCode"=t12."Code" left join RIN1 t13 on t1."DocEntry"=t13."BaseEntry" left join ORIN t14 on t13."DocEntry"=t14."DocEntry" where t1."Series" != 97
De antemano agradezco por su ayuda.