title: Inner Join BETWEEN two values
body: <p>I'm currently trying to populate my fact table and I'm having trouble populating the required time ID's. The time dimension is fully populated and complete. Basically in the time dimension each row is a 15 minute period. The fact table is populating details about calls. And in a staging call table I have the start and end time of the call.</p>
  
  <p>I'm wanting to populate the fact table by joining the dimension On the staging table by the time start and when the time_Start in the dimension is between the start and end time in the staging.. I've ran the query below using the = operator but it does not seem to work and only pulls out 100 rows when i should be expecting more like 4000. Can i use BETWEEN instead of the = ?</p>
  
  <pre><code>INNER JOIN Time_Dim ON incoming_measure.StartTimeDate = Time_Start
  WHERE Time_Start BETWEEN incoming_measure.StartTimeDate AND incoming_measure.EndTimeDate
  </code></pre>
  
  <p>Thanks for the help.</p>