Hello all,
I was able to adjust my code and got it to work:
SELECT SA.eid, SA.last, SA.first, TO_CHAR(SA.week, 'YYYY-MM-DD') as Week, SA.event, AA.reason, TO_CHAR(AA.date, 'YYYY-MM-DD') as Date
FROM schedule_assignments as SA
LEFT OUTER JOIN
availability_and_attendance as AA
ON SA.eid = AA.eid
WHERE AA.date BETWEEN SA.week and SA.week + INTERVAL '7 DAY'
Group by SA.eid, SA.last, SA.first, SA.week, SA.event, AA.reason, AA.date
HAVING (AA.Reason = 'R') OR
(AA.Reason = 'V')