Thanks Mark,

But I still have some problems. The totals came out correct but I want to see the course with no textbooks and when I put the where statement in it gets rid of it.

select course.courseid, coursematerial.textid, sum(textbook.cost);
from course left join coursematerial on course.courseid = coursematerial.courseid, textbook;
where textbook.textid = coursematerial.textid;
into table temptext;
group by course.courseid

Any ideas as to why?
Thanks,
Tyler