 <p>You had a wonky join. Try:</p> <pre><code>select A1.* from Asset A1 left join AuditedItems A2 on A1.asset_number = A2.asset_number where A1.location_id = 15 and A2.asset_number is null </code></pre>