title: I'm using MS Access 2016 SQL to create a nested JOIN clause but I seem to get an error
body: <pre><code>SELECT 
      (invoice.invoice_id) AS invoice_id, 
      COUNT (line_item.code) AS code, 
      SUM (price)
  FROM
      invoice 
  INNER JOIN 
      (line_item 
  INNER JOIN 
      (stock_item) ON line_item.code = stock_item.code) ON invoice.invoice_id = line_item.invoice_id;
  </code></pre>