var lst1 = from a in tbl1 select new {Date=a.Date,User=a.User}; var result = from b in tbl1 join u in lst1 on b.User equals u.User Select b;
var result = from b in tbl1 join (from a in tbl1 select new {Date=a.Date,User=a.User};)u on b.User equals u.User Select b;
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)