Strangely when I run the query
SELECT inbox.inboxID, inbox.newUserID, inbox.applicationID, inbox.inboxDate, people.peopleID, people.firstname, people.lastname, people.salutationID, application.applicationID, application.peopleID, applicationperson.firstname, appilcationperson.lastname
the application.fisrtname and application.lastame shows in the query however people.firstname and people.lastname dissapears. If I remove the
LEFT JOIN people AS applicationperson ON application.peopleID=applicationperson.peopleID
then people.firstname and people.lastname appears in the sequel query again. I am not quite sure why this is happening.