title: Why am I getting a syntax error on these joins?
body: <p>I'm getting the</p>
  
  <pre><code>Syntax error in JOIN operation
  </code></pre>
  
  <p>error on this query.  This suggests that there's a misplaced parenthesis somewhere in the joins, but I can't figure out what's wrong.</p>
  
  <pre><code>select *
  from
  ((ss
  left join
  sc
  on
  ss.guid=sc.guid)
  left join
  mrc
  on
  format(c.xDate, "yyyymmddHHMMSS")=mrc.xDate)
  left join
  c
  on
  sc.cID=c.id
  </code></pre>