I need help with a sql query. To make it easier to understand I

created an image. Please click on link below to see the image.

http://realestate.ithighway.co.uk/upload/sqlQuery.gif


Thanks!