select *
from intent_student_info isi
left join stu_followup_rec_data sfrd on followup_time=(select max(followup_time)
from stu_followup_rec_data where stu_id = isi.stu_id )
where isi.school_visible_flag='0'