title: Error -- SQL Compilation Error: syntax error line 1 at position 0 unexpected 'INNER'
body: <p>I am trying to perform an inner join on two tables by date and county ID. Whenever I run the query, I get the following error:</p>
  <pre><code>SQL Compilation Error: syntax error line 1 at position 0 unexpected 'INNER'
  </code></pre>
  <p>The code is as follows:</p>
  <pre><code>SELECT  
       ISO3166_1,
       FIPS,
       DATE,
       CASES
  FROM
       &quot;covid-19&quot;,&quot;public&quot;.&quot;timeseries&quot;
  WHERE
       ISO3166_1 = 'US'
  INNER JOIN
       &quot;db&quot;.&quot;population_schema&quot;.&quot;pop_table&quot;
  ON
        ((&quot;covid-19&quot;,&quot;public&quot;.&quot;timeseries&quot;.fips = &quot;db&quot;.&quot;population_schema&quot;.&quot;pop_table&quot;.fips)
  AND
        (&quot;covid-19&quot;,&quot;public&quot;.&quot;timeseries&quot;.date= &quot;db&quot;.&quot;population_schema&quot;.&quot;pop_table&quot;.date))
  </code></pre>
  <p>For reference, the date and FIPS data types are the same. Are there any glaringly obvious issues?</p>