Hello,
Does anyone know why this outer join doesn't work......
[
AND TRUNC (SYSDATE) BETWEEN eh.emp_hhold_start_date AND eh.emp_hhold_stop_date (+)
but these do........
AND TRUNC (SYSDATE) >= eh.emp_hhold_start_date (+)
AND TRUNC (SYSDATE) <= eh.emp_hhold_stop_date (+)
Thanks,
Christine