title: SQL update table 1 with id from table 2 if match the name
body: <p>Can anyone help with the following ?</p>
  
  <p>I have 2 tables and I need to update table#1 with data from table#2 like the example below </p>
  
  <p>Table 1 : </p>
  
  <p>ID - Name - Engine ID</p>
  
  <p>1 - x - NULL</p>
  
  <p>Table 2 :</p>
  
  <p>ID - Name </p>
  
  <p>0 - x</p>
  
  <p>Result (in Table 1) :</p>
  
  <p>ID - Name - Engine ID</p>
  
  <p>1 - x - 0</p>
  
  <p>using loop over table 1 </p>