title: Select from MySQL table while ordering by IDs from another table
body: <p>This might be something very simple to do. If so, I apologize. I'm still learning MySQL.</p>
  
  <p>Say, I have two tables:</p>
  
  <pre><code>Table1:
  `id` int autoincrement primary key
  `Name` tinytext
  `Phone` tinytext
  `Date` etc.
  </code></pre>
  
  <p>and</p>
  
  <pre><code>Table2:
  `id` int autoincrement primary key
  `itmID` int
  </code></pre>
  
  <p>Each row in Table2 specifes the order at which elements should be selected out of Table1. <code>itmID</code> field in Table2 is linked to <code>id</code> field in Table1.</p>
  
  <p>So right at this moment to select elements from Table1 I do this:</p>
  
  <pre><code>SELECT * FROM `Table1`;
  </code></pre>
  
  <p>But how do you order them according to Table2, something like this?</p>
  
  <pre><code>SELECT * FROM `Table1` ORDER BY &lt;itmID's in Table2&gt; ASC;
  </code></pre>