service

/*service death*/

select o.vstdate,p.pname,concat(p.fname,space(1),p.lname) as person_name ,p.death,p.discharge_date

from ovst o

inner join person p on p.patient_hn = o.hn

inner join death d on d.cid = p.cid

where d.death_date < o.vstdate

#================