title: SQL Select compared fields from 2 tables as result with no index in a single query
body: <p>EDIT: 
  Link updated,
  Languages: SQL Database (MySQL 5.6.20) and PHP 5.3.
  Sorry for the title, i couldnt find a better one because its hard to discribe without knowing special words :S</p>
  
  <hr>
  
  <p>I have a database with 2 tables. you can see a list of links to images of database and table structure <a href="http://simplepress.24.eu/" rel="nofollow">here</a></p>
  
  <p>i am looking for a query to compare the data and get a result array like this</p>
  
  <pre><code>Array
  (
      [0] =&gt; Array
          (
              [id] =&gt; 1
              [title] =&gt; Ein Titel
              [inhalt] =&gt; Ein Inhalt
              [date] =&gt; 123456789
              [can_comment] =&gt; 1
              [can_upload] =&gt; 1
          )
  
      [1] =&gt; Array
          (
              [id] =&gt; 2
              [title] =&gt; Noch ein Titel
              [inhalt] =&gt; Noch ein Inhalt
              [date] =&gt; 123456789
              [can_comment] =&gt; 0
              [can_upload] =&gt; 0
          )
  
  )
  </code></pre>
  
  <p>thanks in advance</p>