LINQ 左右连接查询 ###################### 100% 结贴
sinlist = sobj.GetListInfo(conditionsql, "id desc");
unlist=uojb.GetListInfo(" Legally='通过' ","");
tsinlist=tsobj.GetListInfo("","");
var resul= from u in unlist
join t in tsinlist on u.UserId equals t.UserId
from s in sinlist join
select new
select * from S left join (select * from T left join U on t.id=u.id) a
on S.ID=a.uid
select * from S left join (select * from T left join U on t.id=u.id) a
on S.ID=a.uid
var query= from s in S
join a in ( from t in T join u in U on t.id equlas u.id into lg
from u in lg.DefaultIfEmpty()
select t) A
on s.ID equlas a.uid into l
from a in l.DefaultIfEmpty()
select s;
from s in S
join t in T on s.sid equals t.id into st
from p in st.DefaultIfEmpty()
join u in U on u.id equals t.id into ut
from gin ut.DefaultIfEmpty()
select s
