title: android sql - how do you order your sql query by multiple columns
body: <p>I am currently working on an Android project in Eclipse and i am having problems with my SQL query.</p>
  
  <p>I am trying to order the query by more than two columns, currently i am doing it by KEY_DAY_ID but i want to also do it by KEY_START_TIME, but i can't get it to work</p>
  
  <p>my query currently looks like this:</p>
  
  <pre><code>Cursor cursor = db.query(TABLE_SESSION, new String[] {KEY_ID, KEY_MODULE_CODE, 
              KEY_DAY_OF_WEEK, KEY_START_TIME, KEY_DURATION, KEY_SESSION_TYPE, KEY_ROOM},
              null, null, null, null, KEY_DAY_ID  + " ASC");
  </code></pre>
  
  <p>Please let me know your thoughts. Thank you in advance!</p>