<select id="byID" resultType="ClubMember"> select a.id as rid,a.register_date,b.name as cname,c.name as mname from Club_Member a,Club b,Member c where a.member_id = c.id and a.club_id = b.id and a.member_id = #{id} </select>
class ClubMember { private int rid; private Date register_date; private String cname; private String mname; ..... }