SELECT
  PATIENT.FIRSTNAME || ' ' || PATIENT.MIDDLEINITIAL || ' ' || PATIENT.LASTNAME PATIENTDISPLAYNAME,
  PATIENT.ADDRESS1,
  PATIENT.ADDRESS2,
  PATIENT.CITY || ', ' || PATIENT.STATE || ' ' || PATIENT.ZIP CITYSTATEZIP,
  PATIENTRECALL.RECALLTYPE
FROM PATIENT
  INNER JOIN PATIENTRECALL ON (PATIENT.PATIENTID = PATIENTRECALL.PATIENTID)
WHERE
  PATIENTRECALL.RECALLDATE >= :STARTDATE AND
  PATIENTRECALL.RECALLDATE <= :ENDDATE AND
  PATIENT.INACTIVEPATIENT  =  'F' AND
  PATIENTRECALL.RECALLSTATUS <> 'rsCancelled' AND
  PATIENTRECALL.RECALLSTATUS <> 'rsRecalled' AND
  PATIENTRECALL.RECALLSTATUS <> 'rsMail' AND
  PATIENTRECALL.RECALLSTATUS <> 'rsEMail' AND
  PATIENT.OFFICEID = :OFFICEID AND
  PATIENT.NOMAILINGFLAG = 'F'
ORDER BY
  PATIENT.LASTNAME,
  PATIENT.FIRSTNAME