Hi

I have three level heirarchal data. using the statement below i managed to display two level data. I need to extend it to one more level.

Current heirachy is Modules-->Documents

I need to extend it as Packages-->Modules-->Documents

var data = (from m in DataContext.SysModules
                   join d in DataContext.SysDocuments on m.ModuleID equals d.ModuleID into tempDocs
                   from SysDocument in tempDocs.DefaultIfEmpty()
                   group SysDocument by m).ToList();

Regards Tassadaque