title: How to left join a Cartesian product on another table?
body: <p>Using Access 2010.  Suppose I have three tables: <code>dogs</code>, <code>cats</code>, and <code>catChases</code>.  My goal is to create a query that will tell me, for each dog and each cat, whether or not that dog has chased that cat.</p>
  
  <p>I thought I'd have to use a Cartesian product of <code>dogs</code> and <code>cats</code>, because I want the status for all possible combinations, and then left join <code>catChases</code>, as follows:</p>
  
  <pre><code>select
  dog,cat,chase
  from
  dogs,cats
  left join
  catChases
  on
  dogs.dog=catChases.dog
  </code></pre>
  
  <p>but that just gives me an error message:
  <code>Syntax error in JOIN operation.</code></p>
  
  <p>So how do I left join another table to a Cartesian product?</p>