/* Using the new syntax with the JOIN ON or JOIN USING clause */
/* use USING when the joined columns have the same name  */

SELECT s.lname,  s.fname,  a.street1,  a.city 
FROM   student s  JOIN  address a 
  ON   s.student_id =  a.stu_id
WHERE  s.lname      =  'Davidson';



/* Joining 3 tables */

SELECT s.lname,  s.fname,  course_id,  cl.session_id,  c.description,  c.price
FROM   student s  
JOIN   class cl     
   ON  s.ssn = cl.stu_ssn				/* ON */
JOIN   course c 
USING  (course_id) 					    /* USING */
WHERE  c.description NOT LIKE '%SQL%';