___ Mon May 17 14:41:11 2010 ___________________________________________________
1> select a.propref, b.rateable_value,addr1,addr2,addr3,addr4,
postcode
from nrproperty a, nrchargerec b
where a.propref=b.propref
and b.fin_year=201011
and b.date_to='01.04.2011'
and b.rateable_value >=18000 and b.rateable_value <20001
and b.empty_prop='Y'




+-------------------+-------------+-----------------------------------+-----------------------------------+--------------------------------+--------------------------------+--------+
|propref |rateable_valu|addr1 |addr2 |addr3 |addr4 |postcode|
+-------------------+-------------+-----------------------------------+-----------------------------------+--------------------------------+--------------------------------+--------+
|900500288927 | 19000|STORAGE LAND |BURWELL |ELY |CAMBS |CB25 0AH|
|901000300277 | 19500|2ND FLOOR |8 HIGH STREET |ELY | |CB7 4JY |
|902300270001 | 20000|UNITS 1-2 THE SHADE BUSINESS PARK |BARCHAM ROAD |SOHAM ELY |CAMBS |CB7 5DE |
+-------------------+-------------+-----------------------------------+-----------------------------------+--------------------------------+--------------------------------+--------+
(3 rows)
2> commit


End of Request
________________________________________________________________________________