title: Selecting data from two different tables without using joins
body: <p>I've got <code>table1</code> and <code>table2</code> and need to get data out from each of them.</p>
  
  <p><strong>Table1</strong></p>
  
  <pre><code>"id"    "name"      "description"
  "1"     "Windows"   "Microsoft Windows 8"
  </code></pre>
  
  <p><strong>Table2</strong></p>
  
  <pre><code>"id" "type" "name"              "description"
  "1"  "22"   "Microsoft Windows" "Microsoft Windows 8 Home"
  "2"  "2"    "Not an Edit"       "Not an Edit"
  </code></pre>
  
  <p>I do the select like this</p>
  
  <pre><code>select table1.name, table1.description, 
  table2.name, table2.description 
  from table1,table2 
  where table2.id=table1.id and table2.`type`=22;
  </code></pre>
  
  <p>Will using an inner join be quicker or more efficient when selecting some 500+ rows at a time?</p>
  
  <p>I've seen most examples using a inner join to do this.</p>