title: Update in multiple tables, set multiple value
body: <p>I need to update a one row only about a single day of week.</p>
  
  <pre><code>UPDATE room
  INNER JOIN giorni ON (room.IDRoom = giorni.FKRoom)
  INNER JOIN aperture ON (giorni.FKApertura = aperture.IDApertura )
  SET StatoBloccato = true, 
    Aperto = true, 
    OrarioApertura = '09:00:00', 
    OrarioChiusura = '19:00:00' 
  WHERE giorni.Nome LIKE 'Lun' 
  AND room.IDRoom = 1;
  </code></pre>
  
  <p>The idea is to set <strong>StatoBloccato</strong> as <strong>true</strong>, only for a day 'Lun'.<br />
  But this query set StatoBloccato as <code>true</code> for all days.<br />
  What is wrong?</p>
  
  <p>Here the example: 
  <a href="https://i.stack.imgur.com/cjjFf.png" rel="nofollow noreferrer">here the example</a>
  (it seems to be wont read the <code>WHERE</code> clause)</p>
  
  <p>This is my 3 tables join:
  <a href="https://pastebin.com/n3b3dYvm" rel="nofollow noreferrer">https://pastebin.com/n3b3dYvm</a></p>