title: phpmyadmin SQL query multiple tables
body: <p>I have two tables. <br/>
  (1) compressors<br/>
  (2) crankcase_heaters</p>
  
  <p>I'm trying to create a SQL query to do:</p>
  
  <ul>
  <li><p>Select the <strong>compressor.VOLTAGE</strong> and <strong>compressor.WATT</strong> of each <strong>compressor.PART_NUMBER</strong> </p></li>
  <li><p>Find the <strong>crankcase_heater.PARTNO</strong> that has the same voltage and watts.</p></li>
  <li><p>Add that value into a new field on the compressor table called "CRANKHTR"</p></li>
  </ul>
  
  <p>Essentially this query will reproduce my compressors table but will have another 'column' called "CRANKHTR". </p>
  
  <p>I'm completely lost on where to even start with this. I tried using the phpmyadmin SQL Query builder but i have no idea where to begin.</p>