title: table is specified twice both as a target for INSERT and as separate source of data
body: <p>I made this query but it gave me error just like in the title</p>
  
  <pre><code>INSERT INTO data_waktu_vaksinasi (id_binatang, id_vaksin, tanggal_vaksin, status_vaksin) VALUES 
      (1, 1, (SELECT DATE_ADD(max(tanggal_vaksin), INTERVAL 1 YEAR)) FROM data_waktu_vaksinasi, 'belum')
  </code></pre>