SELECT o.hn,p.pname,p.fname,p.lname
FROM oapp o
LEFT OUTER JOIN patient p ON p.hn = o.hn
WHERE o.nextdate = '2006-10-01' AND o.hn IN (SELECT hn FROM clinicmember WHERE clinic='001')
AND o.hn IN (SELECT hn FROM ovst WHERE vstdate BETWEEN '2006-09-28' AND '2006-10-03' )