Student Scheduling Query

I'm trying to create a student demographic and schedule extract for a data analysis product called OARS. The query I have works well with 1 period/course, as at an elementary school, or one course from a Middle School.

However they are asking me for course, section, and period information for all six periods for each student at both of our middle schools. On top of that we have courses that meet on A days, B days, and A-B days. To add to the problem, OARS wants a unique line for each student for each course in addition to the demographic information. Which I think is odd but thats what they want.

im worried that my limited SQL skill set is not up to this part of the task. Any insight into this problem would be greatly appreciated. My query is very basic (don't laugh) but works, and currently looks like this for each elementary school. I use the UNION command to pull the schools together in one file.

I've attached a text file of the query as it seemed the thing to do.

Any help would be appreciated.

Let me know what you think.

- Sez