Problema con JOIN

[echo_]

Gracias por el apoyo, lo he hecho de otra forma y si corre pero al agregar la ultima linea no, tu que crees que sea?

Código MySQL:

SELECT todos_los_leads.idperson, todos_los_leads.firstName, todos_los_leads.lastName, todos_los_leads.telephone, todos_los_leads.degreeOfInterest, leads.appointmentDate, leads.marketingSource, infonavit.marketability, leads.monthlyIncome, todos_los_leads.createdDate, todos_los_leads.infoLastUpdated
FROM todos_los_leads
INNER JOIN leads ON todos_los_leads.idperson = leads.idPerson
INNER JOIN infonavit ON todos_los_leads.idInfonavit = infonavit.idinfonavit
WHERE todos_los_leads.telephone = '[phone]';