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

select (d.icode)as HospDrugCode,(d.na)as ProductCat,(d.na)as TMTID,(d.na)as SpecPrep,d.generic_name,r.tradename,(d.na)as DSFcode,r.dosage_form,r.strength,(d.units)as Content,
d.unitprice,(d.na)as Distributor,(r.comp)as Manufacturer,(case when d.drugaccount in (‘¡’,’¢’,’¤’,’§’,’¨1′) then ‘E’ else ‘N’ end)as ISED,(d.did)as NDC24,(d.na)as Packsize,
(d.na)as PackPrice,(d.na)as UpdateFlag,(d.na)as datechange,(d.na)as dateupdate,(d.lastupdatestdprice) as DateEffective

from drugitems d
left join drugitems_register r on r.std_code=d.did
where d.istatus=’Y’
group by d.icode