Schedule Facility Query

scheduleByFacility.sql

Select 
  RXInfo.Patient, 
  RXInfo.Number, 
  Facility.Name, 
  RxInfo.RefillNumber 
From scriptassist.RXInfo AS RXInfo 
Left Join scriptAssist.Patient As PatientT On PatientT.PatientId = RXInfo.PatientID  
Left Join scriptAssist.Facility On Facility.FacilityID = PatientT.FacilityID 
Where 
  RXInfo.Schedule In ('2','3','4','5') 
  And ISNull(PatientT.FacilityID, 0) > 0 
Order By 
  Facility.Name, 
  RxInfo.Patient, 
  RxInfo.Number, 
  RXInfo.RefillNumber