title: SQL Server CE joining two tables
body: <p>I have 2 tables, <code>tb1</code> is users and <code>tb2</code> is stats.</p>
  
  <p>I have multiple stats for each user marked with a timestamp</p>
  
  <p>I wanted a query where I could get the latest stat for each user I tried a lot of things but SQL Server CE seems a little bit limited...</p>
  
  <p>Can someone give me a hint on how to perform it?</p>