title: SQLite in Android How to update a select set?
body: <pre><code>    UPDATE event
  SET EVENT_PROCESS = 4
  WHERE
      LEARNING_EVENT_GROUP_ID IN (
          SELECT DISTINCT
              LEARNING_EVENT_GROUP_ID
          FROM
              event
          WHERE
              EVENT_TYPE = 1
          AND EVENT_PROCESS != 4
          AND (
              (
                  (
                      EVENT_SEQUENCE = 1
                      OR EVENT_SEQUENCE = 2
                  )
                  AND 1463681631460 &gt;= (
                      EVENT_EXPECTED_FINISHED_DATE + 86400000
                  )
              )
              OR 1463681631460 &gt;= (
                  EVENT_EXPECTED_FINISHED_DATE + 172800000
              )
          )
      )
  </code></pre>
  
  <p>Here is my sql,
  I want to update EVENT_PROCESS to 4 depends on the select set,but it didn't work on my project,without error. 
  If SQLite does not support like this,What am I supposed to do?</p>