根据常用电子邮件地址加入SQL结果集

I have one table that contains both students and parents records. There is a common field (email address) in both parent and student records that match the records (parents and students have the same email address). that contains both students an