title: MySQL request from two tables interacting with each other
body: <p>Tables i have
  <strong>Table1</strong> <code>user_id, date</code>
  <strong>Table2</strong> <code>user_id, status</code></p>
  
  <p>I need something like</p>
  
  <pre><code>UPDATE Table2 
     SET status = 2  
     WHERE user_id in ( {SELECT user_id FROM Table1 WHERE date &gt; 0} )
  </code></pre>
  
  <p>In other words i need to see if date in table1 is more than 0000-00-00 then grab user_id of people who match this criteria and use them in table2 to set their status to 2.
  Problem is that i need to do it for more than one user so request inside request does not work for me, it only works when there's one row in result.</p>