SELECT school_name FROM d_guidance INNER JOIN m_school ON d_guidance.school_id = m_school.school_id WHERE guidance_date = '2012/05/19' GROUP BY school_name, m_school.school_id ORDER BY m_school.school_id<BR>