 <p>I don't see any relationship between those two tables.</p> <p>In your <code>uploads</code> table definition change this</p> <pre><code>`member_school_id` int(11) NOT NULL DEFAULT 1 </code></pre> <p>Remove quote from <code>member_school_id</code> since it's a <code>INT</code> field. </p> <pre><code>SELECT uploads.*, audienceuploadassociation.* FROM uploads JOIN audienceuploadassociation ON uploads.upload_id = audienceuploadassociation.upload_id WHERE uploads.member_id = '1' AND uploads.member_school_id=1 AND uploads.subject = 'ESL' AND uploads.topic = 'Poetry' LIMIT 20 </code></pre>