complex mysql join for dataassist results page
I am currently struggling to understand how I can get some values from a complex mysql join.
The values I am trying to get are people.firstname and people.lastname. This works perfectly with my first LEFT JOIN
but I do not know how I can creat/filter people.firstname and people.lastname to be assigned to my third left join
my sql statement look like this
LEFT JOIN people ON inbox.newUserID=people.peopleID
LEFT JOIN application ON inbox.appilicationID=application.applicationID
LEFT JOIN application AS applicationperson ON people.peopleID=applicationperson.peopleID