Steve,

select * from application a
where a.posted >= to_date('27-OCT-2000','dd-mon-yyyy') and a.posted <= to_date('22-NOV-2000','dd-mon-yyyy');

will return a lot records.

SQL> r
1 select l.location_number, count(a.application_id)
2 from application a, location l
3 where
4 l.location_id = 102884
5 and l.location_id = a.location_id(+)
6 and a.posted >= to_date('27-OCT-2000','dd-mon-yyyy')
7 and a.posted <= to_date('22-NOV-2000','dd-mon-yyyy')
8* group by l.location_number

no rows selected

SQL>


For who comes to see the orginal question:

SQL> r
1 select l.location_number, count(a.application_id)
2 from application a, location l
3 where
4 l.location_id = 102884
5 and l.location_id = a.location_id(+)
6* group by l.location_number

LOCATION_NUMBER COUNT(A.APPLICATION_ID)
------------------------------ -----------------------
2323 0

I want to see
LOCATION_NUMBER COUNT(A.APPLICATION_ID)
------------------------------ -----------------------
2323 0

for the following query too!
select l.location_number, count(a.application_id)
from application a, location l
where
l.location_id = 102884
and l.location_id = a.location_id(+)
and a.posted >= to_date('27-OCT-2000','dd-mon-yyyy')
and a.posted <= to_date('22-NOV-2000','dd-mon-yyyy')
group by l.location_number
/