Sql Query

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!

Maybe http://www.webdeveloper.com/forum/fo...=30&forumid=41 is a better place for such an inquiry :-)