title: Cant get my trigger to work
body: <pre><code>CREATE TRIGGER noOfBooks
  AFTER INSERT ON BooKLoan 
  FOR EACH ROW
  BEGIN 
     UPDATE Book SET noOfLoan=noOfLoans + 1  
     WHERE Bookloan.bookTitle= :new.bookTitle;
  END;
  /
  </code></pre>
  
  <p>(adding one to the noOfLoans column for a book title in table Book, after each time that book title is entered into a new loan row in table BookLoan)</p>
  
  <p>Can anyone help me to the solution please ? </p>