8,497
社区成员
发帖
与我相关
我的任务
分享
var query= from t1 in db.table1
join t2 in db.table2
on t1.ID equals t2.table1ID
where t2.userID == userID
select t1;
var query= from t1 in db.table1
where db.table2.Where(t2=>t2.table1ID==t1.ID).Select(t2=>t2.userID)
.Contains(userID)
select t1;