Unknown column 'InstructorID' in 'on clause'

I have seen this error on this forum before and I have read the help documents and PHP information on changing this statement to 5.*, however, I can't seem to get it right.

What I have is:

$Query = runquery(
'SELECT Dispatch.*, Student.FirstName AS SFirstName, Student.LastName AS SLastName, Instructor.FirstName AS IFirstName, Instructor.LastName As ILastName
FROM Dispatch, Student
LEFT JOIN Instructor ON InstructorID = Instructor.ID
WHERE Student.ID = Dispatch.StudentID ');

Unfortunately I am getting an error, despite how I try to re-write this code which states:

Error was: Unknown column 'InstructorID' in 'on clause'

Can anybody else me better understand why this is occuring? I know that I need to re-write the LEFT JOIN but I am not entirely sure how.

Thank you.

nope, it's your inner join that needs re-writing

as to why it's happening, search this forum for "unknown column" -- this has been answered a couple dozen times since mysql went from version 4 to version 5

which table is InstructorID in?

Thank you for that. I managed to get it to work with a little trial-and-error on the INNER JOIN

I ended up with:

$Query = runquery(
'SELECT Dispatch.*, Student.FirstName AS SFirstName, Student.LastName AS SLastName, Instructor.FirstName AS IFirstName, Instructor.LastName As ILastName
FROM Dispatch
INNER JOIN Student on Student.ID
LEFT JOIN Instructor ON InstructorID = Instructor.ID
WHERE Student.ID = Dispatch.StudentID

Instructor.ID is in the Dispatch Table.

Sorry, I meant to say that that it was in the Dispatch Table

that's incomplete

that will actually join every row of dispatch to every row of student, because Student.ID by itself is going to evaluate as TRUE

your WHERE clause then throws almost all of the joined rows away

what you need to do is move the WHERE condition to that INNER JOIN's ON clause