___ 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
________________________________________________________________________________