title: Making a query between three access tables does not return value
body: <p><a href="https://i.stack.imgur.com/nOrSI.png" rel="nofollow noreferrer">enter image description here</a><img src="https://i.stack.imgur.com/g0Z0k.png" alt="enter image description here">I have three Access tables. I tried to make a query depend on date, but the query does not return any value.</p>
  
  <pre><code>SELECT Sum(income2.mony) AS SumOfmony, Sum(outcome.mony) AS SumOfmony1, Sum(PT.PT_Paid) AS SumOfPT_Paid, Sum(PT.PT_Remain) AS SumOfPT_Remain, PT.PT_Date
  FROM (PT INNER JOIN income2 ON PT.PT_Date = income2.dat) INNER JOIN outcome ON PT.PT_Date = outcome.[dat&amp;time]
  GROUP BY PT.PT_Date;
  </code></pre>
  
  <p><a href="https://i.stack.imgur.com/khXUp.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/khXUp.png" alt="enter image description here"></a></p>