Ahh...  Yes, so it would be something like this....
SELECT c.course_name AS CourseName, c.course_number AS CourseNum, c2.course_name AS PreName, c2.course_number AS PreNum
FROM Prereq p
INNER JOIN  Course c ON...

I figured it out!
SELECT c.course_name AS CourseName, c.course_number AS CourseNum, c2.course_name AS PreName, c2.course_number AS PreNum
FROM Prereq p, Course c, Course c2
WHERE p.course_number = c.course_number
AND p.prereq...

Thanks for your help!  This is a lot more complicated that I had anticipated....  I'm exploring the ranking...

The periodic can only have 1 date.... 

The type...

So I'm getting closer...
SELECT t.id, Max(t.type) AS MaxOftype, Max(t.date1) AS MaxOfdate1
FROM Table1 AS t
WHERE (((t.type) Is Null Or (t.type)="" Or (t.type)="periodic"))
GROUP BY t.id;

I get...

I've tried
select id, type, date1from Table1 as t
where (t.type Is