title: Sql Between Clause for multiple columns
body: <p>I try to implement a query by using Between Clause,but there is some problem in this</p>
  
  <p>first query for S_E1:</p>
  
  <p>this query return exact data which i require and here data count is 43.</p>
  
  <pre><code>select RECORD_TIMESTAMP as DateRecorded, ROUND (S_E1 ,2 )as S_E1
  from TBL_SENSORS
  Where RECORD_TIMESTAMP Between '4/28/2012 12 :00 AM' 
                             and '5/17/2012 12 :00 AM'
  And ( S_E1 Between 10 And 100 )
  </code></pre>
  
  <p>Second Query for S_E2:</p>
  
  <p>this query return exact data which i require and here data count is 68.</p>
  
  <pre><code>select RECORD_TIMESTAMP as DateRecorded, ROUND (S_E2 ,2 )as S_E2
  from TBL_SENSORS
  Where RECORD_TIMESTAMP Between '4/28/2012 12 :00 AM'
                             and '5/17/2012 12 :00 AM'
  And ( S_E2 Between 10 And 100 )
  </code></pre>
  
  <p><strong>Problem :</strong></p>
  
  <p>But when i combine these to queries in a single query then it give wrong data.It gives me 73 rows.I think it should give 111 rows</p>
  
  <pre><code>select RECORD_TIMESTAMP as DateRecorded, 
         ROUND (S_E2 ,2 )as S_E2, 
         ROUND (S_E1 ,2 ) as S_E1
  from TBL_SENSORS
  Where RECORD_TIMESTAMP Between '4/28/2012 12 :00 AM'
                             and '5/17/2012 12 :00 AM'
  And ( S_E2 Between 10 And 100) 
  and (S_E1 Between 10 And 100  )
  </code></pre>
  
  <p>Please give some idea where i am wrong here..</p>