title: Getting data from two tables with SUM quantity of within certain period of Time
body: <p>I have 2 tables below:</p>
  
  <p><strong>Orderdetails</strong></p>
  
  <pre><code>OrderNumber
  quantityordered
  priceEach
  </code></pre>
  
  <p><strong>Orders</strong></p>
  
  <pre><code>OrderNumber
  orderDate
  </code></pre>
  
  <p><strong><em>Question:</em></strong>
  orderDate look like this: <code>2005-01-01. 2005-02-01. 2003-04-30.....etc</code>.
  The total sum of sales = quantityordered * priceEach</p>
  
  <p>I have to find out the todal SUM of sales in Feb 2005 ONLY
  So far I have: </p>
  
  <pre><code>SELECT orderdate FROM orders WHERE orderdate LIKE'2005-02%';
  </code></pre>
  
  <p>AND</p>
  
  <pre><code>SELECT sum(quantityordered * priceEach) as Total FROM orderdetails;
  </code></pre>
  
  <p>However, how can I combined these 2 into 1 to answer the question?
  Greatly appreciate for your great help in advanced!</p>
  
  <p>AlexK</p>