title: DELETE FROM + LEFT JOIN SNOWFLAKE
body: <p>I'm trying to delete rows from table using delete.</p>
  <pre><code>delete a
  from &quot;table1&quot; as a
  LEFT JOIN &quot;table2&quot; AS b 
  on a.&quot;x&quot; = b.&quot;x&quot; 
  where b.&quot;X&quot; = 'X'
  </code></pre>
  <p>but everything I get is</p>
  <blockquote>
  <p>SQL compilation error: syntax error line 1 at position 7 unexpected 'a'. syntax error line 3 at position 0 unexpected 'LEFT'.</p>
  </blockquote>
  <p>Can you please help me ?</p>