title: Error #1109 - unknown table in field list caused by trigger
body: <p>This is my trigger. </p>
  
  <p>I want to make trigger on 1 table (pelayanan). </p>
  
  <pre><code>CREATE DEFINER=`root`@`localhost` TRIGGER `before_insert_pelayanan` 
  BEFORE INSERT ON `pelayanan` FOR EACH ROW 
  IF NEW.`ESTIMASI` IS NULL OR NEW.`ESTIMASI` = 0 AND
      `dbhpl`.`pelayanan`.`DAYA` &lt;= 5500 
      THEN SET NEW.ESTIMASI = 4; 
  ELSEIF NEW.ESTIMASI IS NULL OR NEW.ESTIMASI = 0 AND
      `dbhpl`.`pelayanan`.`DAYA` &lt;= 33000 AND 
      `dbhpl`.`pelayanan`.`DAYA` &gt;= 6600 
      THEN SET NEW.ESTIMASI = 15; 
  ELSEIF NEW.ESTIMASI IS NULL OR NEW.ESTIMASI = 0 AND
     `dbhpl`.`pelayanan`.`DAYA` &lt;= 197000 AND 
     `dbhpl`.`pelayanan`.`DAYA` &gt;= 41500 
      THEN SET NEW.ESTIMASI = 40; 
  ELSE SET NEW.ESTIMASI = 100; 
  END IF
  </code></pre>
  
  <p>When I execute the trigger, it has been created. But, when I insert data into table pelayanan, It become </p>
  
  <blockquote>
    <p>#1109 - Unknown table 'pelayanan' in field list. </p>
  </blockquote>
  
  <p>How can I resolve this?</p>
  
  <p>I have to remove <code>dbhpl.pelayanan.DAYA</code> become <code>pelayanan.DAYA</code> and <code>DAYA</code>. But, It doesn't work. </p>