 <pre><code>SELECT a.* FROM a LEFT JOIN b USING (signup) WHERE b.id IS NULL AND *signup thingie*; </code></pre> <p>though this is the way to select rows that have no match I do not see how you want to get the desired result from these tables, I believe you missed something in your illustration.</p>