title: Writing a simple MySQL replace query
body: <p>I've got two tables, one that looks like this:</p>
  
  <pre><code>ID | Date ID | Data
  </code></pre>
  
  <p>And another that looks like this:</p>
  
  <pre><code>Date ID | Date
  </code></pre>
  
  <p>Can you help me construct a query that will basically eliminate the need for the second table? I'd rather have the first table be: <code>ID | Date | Data</code></p>
  
  <p>If this isn't possible with a MySQL query, is there a quick PHP script that I should write to do this?</p>
  
  <p>Thanks in advance!</p>