rd.rslt_dt <> '01-Jan-0001'


DECODE(rd.rslt_dt, '01-JAN-01', ri.actl_dt, rd.rslt_dt) as rslt_dt,
PS; if you cant tell the difference between the following two STRINGS:

'01-Jan-0001'
'01-JAN-01'

then (to be blunt) you really need to read a little more before attempting to write SQLs. To a programmer, those strings are about the same as 'chalk' and 'cheese' - they are different lengths and the only thing they have in common are starting with the same few characters.

Computers are precise creatures, they demand precise thinking..