~[tlist_sql;
SELECT
s.last_name last_name,
s.first_name first_name,s.home_room,
bn.note note,
bn.no_days no_days,
to_char(bn.start_date,'mm/dd/yyyy') start_date,
to_char(bn.end_date,'mm/dd/yyyy') end_date
FROM U_BUS_NOTES bn
JOIN students s ON bn.studentsdcid = s.dcid
WHERE s.schoolid = ~(curschoolid)
AND trunc(sysdate) BETWEEN bn.start_date AND bn.end_date
ORDER BY s.last_name, bn.start_date desc
;nonemessage=