title: "from" is not valid at this position, expecting: EOF, ";"
body: <p>I try to increase John Smith salary by 10% and assume I don't know the emp_number for John Smith.</p>
  
  <pre><code>update m
      set m.mon_hourly_pay_rate = m.mon_hourly_pay_rate*1.1
  from monthly_pay m
  inner join Employee e
      on e.emp_number=m.emp_number
  where e.emp_name = "John Smith";
  </code></pre>
  
  <p>Could anyone please help me. the word from have a red underline said "from" is not valid at this position, expecting: EOF, ";" but i google it and have not thing wrong with it</p>