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

Question

I am trying to log id from users table and jobname from jobs 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 whitespace between identifiers such as your table name and keywords such as where:

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