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