title: Adventure Works Database Query producing empty output
body: <p>I am using following tables from adventure work to write a query:</p>
  
  <p><img src="https://i.stack.imgur.com/4j2Jl.png" alt="enter image description here"></p>
  
  <p>The table FactInternetSales table has FK OrderDateKey, DueDateKey and ShipDateKey Assosiate with DateKey in DimDate table. </p>
  
  <p>I have wrote following query to test:</p>
  
  <pre><code>SELECT dd.DateKey, dd.EnglishMonthName, fis.TotalProductCost
  FROM DimDate AS dd INNER JOIN FactInternetSales AS fis 
  ON dd.DateKey = fis.OrderDateKey AND dd.DateKey = fis.DueDateKey
  AND dd.DateKey = fis.ShipDateKey
  </code></pre>
  
  <p>Above query produces empty output. I've checked the data in the FactInternetSales table and it has FK that associates with PK in the DimDate Table.What would be possible cause of this problem?</p>
  
  <p>Please advise? Thanks in advance! </p>