select i.pcode,i.sum_name,i.classid,i.sno,j.classname from m_member i left join m_class_id j on i.classid=j.classid where i.pcode='567'