C# ling to sql 左表连接再内连接
var list = (from a in _XXReadContext.taba join b in _XXReadContext.tabb on a.id equals b.resume_id into a_left from left_a in a_left.DefaultIfEmpty() join c in _XXReadContext.tabc on left_a.skill_id equals c.id where a.id==id select new ResumeResponse { Tname= c.Tname }).Distinct().ToList();
注意: 左连接、内连接,一定是左表的字段放在equals左边,或先查的表,放在左边