title: Opposite of INNER JOIN with EXIST requirement
body: <p>If inner join requires that a row exists, what's the opposite of it without having to do a sub query of <code>NOT EXISTS</code>?</p>
  
  <p>I replaced</p>
  
  <pre><code> AND NOT EXISTS (
    SELECT
     *
    FROM topic_read_assoc
    WHERE topic_id = topic.id
     AND member_id = ".$this-&gt;tru-&gt;application-&gt;currentMember-&gt;getId()."
   )
  </code></pre>
  
  <p>with </p>
  
  <pre><code>OUTER JOIN topic_read_assoc ON (
   topic_read_assoc.topic_id = topic.id AND
   member_id = member_id = ".$this-&gt;tru-&gt;application-&gt;currentMember-&gt;getId()."
  )
  </code></pre>
  
  <p>and it's not producing the same results as the first query (which works)</p>