 <p>To get <strong>just</strong> those records that ARE in Encounter and NOT in EnctrAPR, then just use <code>left outer join</code> instead of <code>full outer join</code>, and add a clause excluding null values for EnctrAPR.EncounterNumber.</p> <p>i.e.</p> <pre><code>SELECT Encounter.EncounterNumber, substring(Encounter.EncounterNumber,4,9) as Acct, ... EnctrAPR.APRDRG, Age18, Age18To64, Age65 from Encounter left outer join EnctrAPR on substring(Encounter.EncounterNumber,4,9) = EnctrAPR.EncounterNumber where EnctrAPR.EncounterNumber is null and HSP# = 1 and InOutCode = 'I' and ActualTotalCharge &gt;0 and AdmitSubService &lt;&gt; 'SIG' and [DischargeDate - CCYYMMDD] between @StartDate and @EndDate and Encounter.Age &gt;= 18 </code></pre> <p>Note though that the value for <code>EnctrAPR.APRDRG</code> will always be null, as EnctrAPR doesn't have a matching row.</p>