title: SQL Join (all from one table and one from another)
body: <p>I am trying to retrieve all fields from one table on [condition1] and combine one field from another table in the results on [condition2], but my joins are not too hot yet:</p>
  
  <pre><code>SELECT * FROM table1 WHERE myField=123
  INNER JOIN table2
  SELECT myField2 FROM table2
  ON (table1.condition = table2.condition AND table1.condition2 = table2.condition2)
  </code></pre>
  
  <p>Assistance is appreciated</p>