/* Joining 3 tables - Old syntax */

SELECT s.lname,  s.fname,  cl.course_id,  cl.session_id,  c.description,  c.price
FROM   student s,  class cl,  course c
WHERE  s.ssn = cl.stu_ssn			    /* joining first two tables    */
  AND  cl.course_id = c.course_id		/* joining result to 3rd table */
  AND  c.description LIKE '%SQL%';



/* Joining 3 tables - New syntax */

SELECT s.lname,  s.fname,  cl.course_id,  cl.session_id,  c.description,  c.price
FROM   student s 
JOIN   class cl  ON  s.ssn = cl.stu_ssn
JOIN   course c  ON  cl.course_id = c.course_id
WHERE  c.description LIKE '%SQL%'