So, what kind of output do you see from: select distinct revwmonth||' '||revwyear from site_details s, activity a where revwyear is not null and s.cllocn=a.cllocn and a.outcome is null and revwmonth is not null and revwmonth!=' ' / ? -- Jared Still Certifiable Oracle DBA and Part Time Perl Evangelist -- //www.freelists.org/webpage/oracle-l