title: Multiple Between Statements
body: <p>I'm a student developer currently taking a SQL course. I'm currently trying to retrieve the sum of several groups of rows from a table. I'm very new to SQL development and I'm not too sure what the problem is in the following scenario. I have a large table of which I want to select specific rows from and then add the balance column.</p>
  
  <p>The following will not display any data in the results and I'm not too sure why. I have a hunch that the between statement can only be used once per table but maybe I'm wrong?</p>
  
  <pre><code>Select Description, SUM(Balance) AS Total_Balance
  FROM Chart_Of_Accounts
  WHERE (Account BETWEEN ('400401') AND ('400407')) 
  AND (Account BETWEEN ('440094') AND ('440100')) 
  AND (Account BETWEEN ('450094') AND ('450100'))
  GROUP BY Description, Balance 
  </code></pre>
  
  <p><em><strong>Edit 10.1.2012</em></strong> As requested by (Richard aka cyberkiwi)</p>
  
  <p><strong>What I Have</strong></p>
  
  <pre><code>Set 1
  |Account        |Description         |Balance
  |4004xx         |Red Wine            |$2361.23
  |4004xx         |White Wine          |$3620.23
  |4004xx         |Rice Wine           |$1223.23
  
  Set 2
  |Account        |Description         |Balance
  |4400xx         |Red Wine            |$4361.23
  |4400xx         |White Wine          |$3260.23
  |4400xx         |Rice Wine           |$223.23
  
  Set 3
  |Account        |Description         |Balance
  |4500xx         |Red Wine            |$1361.23
  |4500xx         |White Wine          |$1620.23
  |4500xx         |Rice Wine           |$1223.23
  </code></pre>
  
  <p><strong>Result I'm Trying to Achieve</strong></p>
  
  <pre><code>Total
  |Description         |Total_Balance
  |Red Wine            |$8083.69
  |White Wine          |$8500.69
  |Rice Wine           |$2669.69
  </code></pre>
  
  <p>thank you for reading my post! I am also open to any advice in SQL development and any feedback is greatly appreciated.</p>