How can I make a left join?

[robertovaldesperez]

public override void VisitGroupJoinClause(GroupJoinClause groupJoinClause, QueryModel queryModel, int index)
{
	throw new NotImplementedException();
}

Does not work for me

var queryI = GetAllQueryable().Where(w => (w.Repeated == null || w.Repeated == false) && w.Scope == true && w.Perimeter == Perimeter.INCLUDED && w.DevelopmentId == developmentId);
            var estateIds = queryI.Where(w => w.EstateCadastralReference != null && w.EstateCadastralReference.Trim() != string.Empty).Select(w => string.Concat("'", (w.EstateCadastralReference ?? string.Empty), "'"));
            var queryP = CurrentSession.Query<CadastralConstructiveElement>().Where(w => estateIds.Contains(w.Property.EstateId)).Select(w => new { w.Property.GuruType, w.TotalArea });

            var query = from i in queryI
                        join p in queryP on i.AssetType.ToString() equals p.GuruType.ToString() into d
                        from d2 in d.DefaultIfEmpty()
                        where i.DevelopmentId == developmentId
                        group i by new { i.AssetType } into gr
                        orderby gr.Key.AssetType == AssetType.FLAT ? 1 : (gr.Key.AssetType == AssetType.HOUSE ? 2 : (gr.Key.AssetType == AssetType.VPO ? 3 : (gr.Key.AssetType == AssetType.OFFICE ? 4 : (gr.Key.AssetType == AssetType.RETAIL ? 5 : (gr.Key.AssetType == AssetType.INDUSTRIAL ? 6 : (gr.Key.AssetType == AssetType.PARKING ? 8 : (gr.Key.AssetType == AssetType.STORAGE_ROOM ? 9 : (gr.Key.AssetType == AssetType.LAND ? 10 : 7))))))))
                        select new
                        {
                            gr.Key.AssetType,
                            // gr.Key.GuruType,
                            AreaCcaa = gr.Sum(w => w.AreaCcaa),
                            Area = gr.Sum(w => w.Area)
                        };
            return query.ToDynamicList();

[hazzik]

Left joins support is limited in NHibernate. Generally it is suggested to use reference properties instead of performing joins in Linq.