select * from table1 where No not in(select subNo from table2) 对应的lambda表达式: var query=table1 .where(U=> ! table2.where(s=>s.subNo==U.No).any()).toList()