Hep B Imms Query

select i.whenimm, i.vaccoutcomecode, i.note, o.descr, o.indicatesgiven from immunisation i
left join vacoutcomeex o on i.vaccoutcomecode = o.vaccoutcomecode
left join vaccantigen g on i.vacccode = g.vacccode
where i.patientid = "X" and i.rowinactive = 0 and g.antigencode = 'HEPB' order by i.whenimm

Index Previous Next