Problem with dates... 2004-10-04 - By Jared Still
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
--
http://www.freelists.org/webpage/oracle-l
|
|
