I have a query that joins two table, and it keeps getting the error.
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '0' at line 1`.
I can't seem to figure out what is wrong here?
I've already check this but in my case it is different.
Here is my query:
$sQuery = "SELECT SQL_CALC_FOUND_ROWS A.id, A.studentNum, B.lastName, B.firstName, B.middleName, B.year, B.courseBlock, B.status, A.facultyloading_id"+
" FROM table_enrolledstudents AS A"+
" INNER JOIN table_student AS B"+
" ON A.studentNum = B.studentNum";
What do you think is wrong? Can you help me? Thank you!