General information
Category:
Coding, syntax & commands
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
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only