โรงพยาบาลจอมพระ

select pv.vaccine_name,pl.vaccine_date,concat(p.pname,p.fname,’ ‘,p.lname)as name,concat(p.age_y,’-‘,p.age_m,’-‘,p.age_d)as age,p.house_regist_type_id,o.vstdate,o.hn,o.icode,(di.name)as namedrug
from opitemrece o
left join person p on p.patient_hn=o.hn
left join person_vaccine_list pl on pl.person_id=p.person_id and pl.vaccine_date=o.vstdate
left join person_vaccine pv on pv.person_vaccine_id=pl.person_vaccine_id
left join drugitems di on di.icode=o.icode
where o.vstdate between ‘2014-01-01’ and ‘2014-08-31′ and (o.icode=’1570007′) and pl.person_vaccine_id in (’14’)
and p.house_regist_type_id in (‘1′,’3’)

0

0