new user - how to pull a list of all students for a specific period along with their teacher

[MichelleRoach]

Hi all,

I am trying to figure out how to pull a report that contains a column of all students name, and a column with their teacher for a specific period that we designate. For instance, we have a HR course within our schedule, and not in the homeroom field, I would like to export a list of all students and their homeroom teacher. It seems easy if we had it corret in the field, but I do not know how to do this since it is set up as a course. Thank you for any help!

[ParatrooperJoe]

Is their a way to split that teachers first and last name in the results?  For example, instead of the result exporting it as "Appleseed, Johnny A"  can we split it so it delivers result as "Appleseed","Johnny A"

[DSegal3440]

Can the teachers name be decode to view as "teachers first and last name" 

[Scott_Hansen]

If you want to go the SQL route, I think this will work for you: (expression is the period id)

SELECT s.lastfirst as student, teachers.lastfirst as teacher, cc.expression
FROM students s
inner join cc on cc.studentid = s.id
INNER JOIN sections on sections.id = cc.sectionid
INNER JOIN teachers on teachers.id = sections.teacher
WHERE cc.expression = '1(A-B)'
AND s.enroll_status = 0