title: How to do a right join (I think) in a query
body: <p>I have sets of data that I want to combine, but they must output to the same data weeks, and missing data should have nulls inserted.  I am not particularly clever with SQL but I think I can explain it.</p>
  <p>So I have dates, sales and products from the start of the year (just imagine there are many products):</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th style="text-align: left;">Date</th>
  <th>Sales</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td style="text-align: left;">02-Jan-2021</td>
  <td></td>
  </tr>
  <tr>
  <td style="text-align: left;">09-Jan-2021</td>
  <td></td>
  </tr>
  <tr>
  <td style="text-align: left;">16-Jan-2021</td>
  <td></td>
  </tr>
  <tr>
  <td style="text-align: left;">23-Jan-2021</td>
  <td></td>
  </tr>
  <tr>
  <td style="text-align: left;">30-Jan-2021</td>
  <td></td>
  </tr>
  <tr>
  <td style="text-align: left;">06-Feb-2021</td>
  <td>2</td>
  </tr>
  <tr>
  <td style="text-align: left;">13-Feb-2021</td>
  <td>3</td>
  </tr>
  <tr>
  <td style="text-align: left;">20-Feb-2021</td>
  <td>5</td>
  </tr>
  <tr>
  <td style="text-align: left;">27-Feb-2021</td>
  <td>3</td>
  </tr>
  <tr>
  <td style="text-align: left;">06-Mar-2021</td>
  <td>2</td>
  </tr>
  <tr>
  <td style="text-align: left;">13-Mar-2021</td>
  <td>1</td>
  </tr>
  <tr>
  <td style="text-align: left;">20-Mar-2021</td>
  <td>0</td>
  </tr>
  <tr>
  <td style="text-align: left;">27-Mar-2021</td>
  <td>2</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>I want my <code>=Query</code> to output the whole time data set, even if there are only limited data (as shown in the table above).  My data will overall contain all the weeks, but each product might only start in the middle or might end once sold out.  But I want my query to always return a full date range.  In Access I would right join my weeks to my sales data weeks, and it would add in all the weeks with nulls.</p>
  <p>How can I do that in sheets with Query (or other methods that hopefully doesn't involve a query per week)?</p>