11 lines
691 B
SQL
11 lines
691 B
SQL
select p.first_name,p.last_name,division,userid,u.email,s1.source,s2.source,s3.source
|
|
from classes,users as u,people as p
|
|
left join hotlunch_order_header as s1 on s1.ordered_by_num = p.record_num and s1.ordered_by_type = 'Student' and s1.schedule_num = 1
|
|
left join hotlunch_order_header as s2 on s2.ordered_by_num = p.record_num and s2.ordered_by_type = 'Student' and s2.schedule_num = 10
|
|
left join hotlunch_order_header as s3 on s3.ordered_by_num = p.record_num and s3.ordered_by_type = 'Student' and s3.schedule_num = 21
|
|
where p.school_num = 1
|
|
and p.class_num = classes.record_num
|
|
and p.people_type = 'Student'
|
|
and p.user_num = u.record_num
|
|
order by division,last_name,first_name
|