SELECT(room_type[room id],[hotel id]=[_THISROW].[hotel name])
room_type[room id]-SELECT(Service Record[room],AND([checkin]<[_THISROW].[checkout],[checkout]>[_THISROW].[checkin],[No]<>[_THISROW].[No]))