SELECT rsinspection.RoomSpaceInventoryInspectionRunID AS RunID, rsinspection.Description AS InspectionDescription, rsitem.RoomSpaceInventoryConditionID AS ConditionID, rsinspection.RoomSpaceID, rscondition.Description AS Condition, SUBSTRING(rsinventory.Description,3,0) AS InventoryDescription, rs.Description AS RoomSpace