SELECT CxcDoc.CxcDoc_Cve AS aCve, CxcDoc.CxcDoc_Doc AS aDoc, CxcDoc.CxcDoc_Num AS aNum, CxcDoc.CxcDoc_Cli AS aCli, CxcDoc.CxcDoc_Nom AS aNom, CxcDoc.CxcDoc_Fec AS aFec, CxcDoc.CxcDoc_Ven AS aVen, CxcDoc.CxcDoc_Imp AS aImp, CxcDoc.CxcDoc_Lim AS aLim, 0.00 AS aAbo, 0.00 AS aSal, CxcDoc.CxCDoc_Tca AS aTca, CxcDoc.CxcDoc_Tip AS aTip, CxcTip.CxcTip_Des AS aDti, CxcDoc.CxcDoc_Pol AS aPol, 0 AS aSta, 0 AS aDia, 0.00 AS aPago, CxcTip.CxcTip_Gpo AS aGpo, '-' AS aGpoCorp, '-' AS aNomCom, '-' AS aDes, CxcDoc.CxcDoc_Erp AS aErp, CxcDoc.CxcDoc_Ref AS aRef, CxcDox.CxcDox_Age AS aAge, CxcDox.CxcDox_NomAge AS aNomAge, CxcDox.CxcDox_Serie AS aSer, CxcDox.CxcDox_Folio AS aFol FROM CxcDoc INNER JOIN CxcTip ON CxcDoc.CxcDoc_Tip = CxcTip.CxcTip_Tip LEFT OUTER JOIN CxcDox ON CxcDoc.CxcDoc_Cve = CxcDox.CxcDox_Cve WHERE CxcDoc.CxcDoc_Cli = '91514'