linq 三表左连接

[baidu_41052487]

三表链接
a 表 左连接 b, a. num=b.num
b左连接 c ;b. msg=c.msg
求助

[peng2739956]

from a in atable 
join  b in btable on a. num equals b.num 
join c in ctable on b.msg equals  c.msg
select {//you need}

[baidu_41052487]

引用 1 楼 peng2739956 的回复:

from a in atable 
join  b in btable on a. num equals b.num 
join c in ctable on b.msg equals  c.msg
select {//you need}

这个是内连吧？我这么写的好像不太对啊