I want to know the course names and the prerequisite ids.
SELECT T1.title,T2.prereq_id FROM course as T1 join prereq as T2 where T1.course_id = T2.course_id
course names refers to title; prerequisite ids refers to prereq_id; joining of tables course and prereq on course_id;