```
select s.sid,s.sname,s.sage,s.team,s.role,ss.zong from students_copy s LEFT join score ss on s.sid = ss.sid
<association property="score" javaType="cn.kgc.tangcco.hsl.pojo.Score">
<result property="bishi" column="bishi"/>
<result property="jishi" column="jishi"/>
<result property="zong" column="zong"/>
</association>
</resultMap>