/* Joining 2 tables with the WHERE clause*/

SELECT lname, fname, course_id
FROM   student, class
WHERE  ssn = stu_ssn;



/* Joining 2 table, plus additional filter */

SELECT lname,  fname,  course_id 
FROM   student,  class
WHERE  ssn = stu_ssn				/* the join */  
AND  ssn < '000-01-0012';			/* additional filter */