title: SQL replace data in table1 from table2
body: <p>Hello i have 2 tables in MySQL DB </p>
  
  <pre><code>status
  id,    name,    date,    status
  1      server1  datum    0
  2      server2  datum    999
  3      server3  datum    999
  4      server4  datum    0
  
  cis
  id,    ,url
  0      img/offline.png
  1      img/server1.png
  2      img/server2.png
  3      img/server3.png
  4      img/server4.png
  999    img/online.png
  </code></pre>
  
  <p>i want to select id and status from status and i want to replace both server_id a and status with url from cis. But i dont know fi this is posible to do or do i need to create a third table for the online/ofline url? </p>
  
  <p>i want to join the tables so that the select returns as this </p>
  
  <pre><code>id,              status  
  img/server1.png, img/offline.png
  img/server2.png, img/online.png
  img/server3.png, img/online.png
  img/server4.png, img/offline.png
  </code></pre>