/* select columns from multiple tables using join */

select lname, fname, email
from   student join student_email
  on   student.student_id = student_email.student_id;