Me sale columnas vacias, yo lo intento hacer asi:
Código MySQL:
Ver originalSELECT tl.idperson
, tl.firstName
, tl.lastName
, tl.telephone
, tl.degreeOfInterest
, l.appointmentDate
, e.firstName
, i.marketability
En todos los leads guardo:
Código SQL:
Ver originalidperson,firstName,lastName,middleName,email,address1,address2,colony,city,idState,zipcode,telephone,cellphone,otherphone,active,idEmployee,idEmployeeCSR,company,LENGTH,POSITION,gender,ssn,maritalStatus,kids,birthDate,createdDate,idFlag,spouse,needFinancing,idMarketingSource,idAccountGroup,idLeadClass,idDistributionChannel,idCustomerClass,idIncomeClass,idProfessionClass,idSalesZone,idTitle,comments,idCommunicationClass,infonavitQualify,visitCount,sessionId,idPersonContact,idEmployeeCSRLead,idEmployeeCSRPostSale,curp,idInfonavit,idSHF,appliesFOVISSSTE,leadType,companyVisited,idCampaing,degreeOfInterest,reallocations,lastAssignment,idBranch,idBranchLead,hasExtras,idEmployeeCSRTitration,idBranchTitration,degreeOfInterestChangedDate,idBranchPostSale,idPersonSAP,idSellersGroup,idNotQualifyReason,idcreditBureau,preQualification,infoLastUpdated,idEmployeeCSRTelemarketing,creditNumber,isSubsidy,folio
En infonavit:
Código SQL:
Ver originalidInfonavit,qualifies,credit,ssv,marketability,expectedDate
Y en SHF:
Código SQL:
Ver originalidSHF,TYPE,monthlyIncome,saveDate1,saveDate2,saveDate3,saveDate4,saveDate5,saveDate6