var linq= from a in sy_pgm_aut
from b in sy_pgm
from c in v_hr_staff
where a.aut_user==c.emp_no && a.pgm_code==b.pgm_code
select new{
emp_ename=c.emp_ename,
pgm_name=b.pgm_name
}
不知道是不是你想要的！我只是个菜鸟！
var query = (table1.Join(tabl3,n=>n.aut_user,m=>m.emp_no,(n,m)=>n.emp_ename))
.Union(tabl1.Join(tabl2,n=>n.pgm_code,m=>m.pgm_code,(n,m)=>m.pgm_name));
内容全部来源于网络收集，如有侵权，请联系网站删除：QQ：24596024