/* Using NATURAL join */
/* this means join on all columns that have the same name in the two tables */

SELECT  s.lname, s.fname, e.email_id, e.email 
FROM    student s  NATURAL JOIN  student_email e