56,678
社区成员
发帖
与我相关
我的任务
分享
select ifnull(sum(`ms`.`SEND_MEDICI_NUM`*`mi`.`MEDICI_PRICE`),0) as s_total from (`fmlyplan`.`medicine_send` `ms` join `fmlyplan`.`medicine_info` `mi`) where ((`ms`.`RECV_MEDICI_UNIT`=2) and (`ms`.`RECV_MEDIC_ISACTIVE` = '0') and (`ms`.`SEND_MEDICI_DT_TM`<='2010'))