lambda expression three tables join

GetQuery<MLTL_RESOURCE_KEYS>()
.Join(GetQuery<MLTL_RESOURCE_VALUES>(), keys => keys.ID, values => values.RESOURCE_ID, (keys, values) => new { keys, values })
.Join(GetQuery<BRN_PARTSTATUS>(), x => x.values.ORGINALID, partstatus => partstatus.ID, (x, partstatus) => new { x, partstatus })
.Where(l => l.x.keys.KEY == "")
.Select(m => new BRN_PARTSTATUS
{
ID = m.partstatus.ID,
PARTSTATUS = m.x.values.VALUE,
ISACTIVE = m.partstatus.ISACTIVE,
ISDEFAULTSTATUS = m.partstatus.ISDEFAULTSTATUS

}).ToList();