问Linq中的右连接，未返回正确的值

EN

var stringMap = from sm in _CRMcontext.StringMaps
                where sm.ObjectTypeCode == 10001 
                && sm.AttributeName == "new_status" 
                || sm.AttributeName == "new_projecttype" 
                || sm.AttributeName == "new_orderstatus" 
                || sm.AttributeName == "new_construction_type" 
                || sm.AttributeName == "new_stage"
                select sm;

var result = from set in ROOMS
             join roomStatus in stringMap on set.Status equals status.AttributeValue
             where roomStatus.AttributeName == "new_status"
             join orderStatus in stringMap on set.OrderStatus equals orderStatus.AttributeValue
             where orderStatus.AttributeName == "new_orderstatus"
             join consructionType in stringMap on set.ConstructionType equals consructionType.AttributeValue
             where consructionType.AttributeName == "new_construction_type"
             select new DTO.Shared.Project() {
                 Id = set.Id,
                 Name = set.Name,
                 RoomStatus = roomStatus.Value,                 
                 OrderStatus = orderStatus.Value,
                 ConstructionType = constructionType.Value,
                 };