门诊配方明细统计

Select C.开嘱时间 as 开单时间,
 C.开嘱医生 as 开单人,
 C.姓名 as 就诊人,
 D.名称 as 协定方名称,
 C.总给予量 as 付数,
 Sum(A.应收金额) as 应收金额,
 Sum(A.实收金额) as 实收金额,
 Sum(Decode(Instr('567', A.收费类别), 0, 0, A.应收金额)) as 药品应收,
 Sum(Decode(Instr('567', A.收费类别), 0, 0, A.实收金额)) as 药品实收
  From 门诊费用记录 A, 病人医嘱发送 B, 病人医嘱记录 C,诊疗项目目录 D
 Where A.医嘱序号 = B.医嘱ID
   And B.医嘱ID = C.ID
   and C.配方ID = D.ID
group by C.开嘱时间 ,
 C.开嘱医生,
 C.姓名,
 D.名称,
 C.总给予量