Column 'hotelid' does not belong to table select distinct a.areapostcode as displayname,(select top 1 town from COUK_postcodes_29sept09 where areapostcode = a.areapostcode) as townname from COUK_postcodes_29sept09 a where a.county = @county ORDER BY a.areapostcode.
Online Booking Hotels CO6