title: How to retrieve data from multiple tables that may or may not have values in common
body: <p>I have looked through everywhere on web and stack overflow but unable to find on how to perform the task as below:</p>
  
  <pre><code>var query = (
      from r1 in db.table1
      where r1.Timestamp == date.ToUniversalTime()
      from r2 in db.table2
          .Where(p =&gt; p.Timestamp == date.ToUniversalTime())
          .DefaultIfEmpty()
      select new
      {
          prod = r1.Value1,
          prod2 = r2.Value1
      })
      .FirstOrDefault();
  </code></pre>
  
  <p>The two tables are not linked to each other but I want to get the data from both the tables in just one query, this is just a sample but in real I have many columns to get the data from.</p>
  
  <p>Apologies if this question is a duplicate but I didnt really find an answer when I searched.</p>
  
  <p>in SQL we can do something like this.</p>
  
  <pre><code>Select r1.*,r2.* from table1 r1, table2 r2
  </code></pre>
  
  <p>How to achieve this?</p>