查询科室负责人.sql 135 B

123
  1. SELECT sa_hospitaldepid,GROUP_CONCAT(doctorname) doctors from sa_doctor
  2. WHERE isleader=1 and siteid=$siteid$
  3. GROUP BY sa_hospitaldepid