title: MYSQL Statement - Pulling from two tables
body: <p>I have two tables in my database.  Each has three things in it:  an identifier which is just a  auto generated number, a text field and an integer field.  The data in the text field (let's call it <code>Names</code>) is the exact same in both tables.  Only the numbers fields are different.  I need the statements to compare the two sets of number fields, and list every name where the number is not zero in either table.  I also need it to add the two numbers together in the fields and and make a separate column with the combined value and list the names by order of that values from highest value to lowest.</p>
  
  <p>This is as far as I have gotten and now I am stuck, I am very new to SQL</p>
  
  <pre><code>SELECT tableone.names
  FROM tableone, tabletwo
  WHERE (tableone.numbers &gt; 0) AND (tabletwo.numbers &gt; 0)
  </code></pre>