/* Using the new syntax with the JOIN ON clause */
/* Joining 2 tables */

SELECT lname, fname, c.course_id
FROM   student s
JOIN   class   c  
on   s.ssn = c.stu_ssn;



/* Joining 3 tables */

SELECT lname, fname, c.course_id, description
FROM   student s
JOIN   class   c  on   s.ssn = c.stu_ssn
JOIN   course  o  on   c.course_id = o.course_id
WHERE  o.description LIKE '%SQL%';