/* creating a Cartesian Product (aka. Cross Join) */

SELECT lname, fname, course_id
FROM   student, class