title: New to trigger, need amendment
body: <p>Two table:</p>
  
  <pre><code>    Customer: Cus_ID, Status
      Payment: Pay_ID, Cus_ID, PaidOrNot
  </code></pre>
  
  <p>Requirement is when setting "Yes" to "PaidOrNot", then automatically set the Customer Status to "VIP".</p>
  
  <pre><code>    CREATE TRIGGER AutoVIP
  
      AFTER UPDATE OR INSERT ON Payment
  
      BEGIN
  
          IF PaidOrNot = Yes
          THEN UPDATE Customer set Status = VIP
  
      END
  </code></pre>
  
  <p>I am quite not familiar with SQL syntax, this trigger seems not working, can you help me to amend it? Thanks.</p>