title: Multiple 'in' statements in a where clause that need to match against each other
body: <p>I have a very long query that is essentially an extension of the following:</p>
  
  <pre><code>update  property.lease_period
  set     scca_uplift = '110',
          scca_notes_code = '21006'
  where   (suite_id = 'CCBG08' and lease_id = '205059')
          or (suite_id = 'CCBG14' and lease_id = '152424')
          or (suite_id = 'CCCF048' and lease_id = '150659')
  </code></pre>
  
  <p>The where clause for this will have ~40 rows when complete. In order to make this task easier I was hoping to do something similar to the following:</p>
  
  <pre><code>update  property.lease_period
  set     scca_uplift = '110',
          scca_notes_code = '21006'
  where   suite_id in('CCBG08', 'CCBG14', 'CCCF048')
          and lease_id in('205059', '152424', '150659')
  </code></pre>
  
  <p>Unfortunately lease_id isn't a unique field and there can be multiple lease_id's to the same suite_id (so subsequently the second query is unusable).</p>
  
  <p>Is there a better way to do the first update statement given that this solution won't work?</p>