Android - SQLiteException: next to "=": syntax error (code 1)

Question

I am trying to write id from users table and jobname from job table using user id

String select = "SELECT jobname FROM " + TABLE_JOBS+ "where userid =" +myid;

Answer 1

"SELECT jobname FROM " + TABLE_JOBS+ "where userid =" +myid;

You need spaces between identifiers, such as your table name and keywords, such as where:

"SELECT jobname FROM " + TABLE_JOBS+ " where userid =" +myid;

Answer 2

You do not have enough space before the sentence where, so it is added directly to the table name, and you actually have no sentence where:

String select = "SELECT jobname FROM " + TABLE_JOBS+ " where userid =" +myid;
// whitespace was missing here -----------------------^