It would be nice if you could help me to figure out on this.
I have web dynamic project in which my database manager works fine. however when I am writing sql query with inner join and where clause it throws exception by claiming syntax error. running the same query from command line works fine. Cant understand whats wrong. Any help would be very much appreciated.
here is my method in database manager
here is my doGet in controller servlet (at this moment I've tested it with flag).
and here is exception thrown
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: 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 '= 3' at line 1