Select pat.patnum from patient pat where pat.patnum in (  

select  p.patnum from procedurelog p join patient pt on p.patnum = pt.patnum 
join procedurecode pc on p.codenum= pc.codenum 
where  DateEntryc > <@OPENDENTAL_LASTD@>
 
 
union
select  pt.Guarantor from procedurelog p join patient pt on p.patnum = pt.patnum 
join procedurecode pc on p.codenum= pc.codenum 
where  DateEntryc > <@OPENDENTAL_LASTD@>
  
union
select  p.patnum from 
adjustment p join patient pt on p.patnum = pt.patnum 
where p.AdjDate > <@OPENDENTAL_LASTD@>
 and p.AdjAmt <> 0
)

