title: SQL multiple where clause
body: <p>I couldn't find if using multiple where clauses like this is valid or not(I use JPA, MySQL) I need multiple where clauses one of them will be a "not" here, or am I missing something?</p>
  
  <pre><code>select d from T_DEBIT d where d.status=PENDING and 
  where not exists (
  select r
  from T_REQUEST r
  where 
  r.debit.id = d.id and
  r.status = SUCCESSFUL
  )
  </code></pre>
  
  <p>Please do ask if you need further information,</p>