Hi LKBrwnDBA,
I did what you said but still get the same results as posted above.
select
s.num,
max(al.AUD_DATE) as changedate,
al.new_value as newdate,
al.old_value as olddate,
m.memfull as whochanged
from
sord s,
ap21log a,
ap21log_audit al,
member m , refcode r
where
s.num in...