Select records from two different table

SELECT * FROM A
INNER JOIN B on A.TempId = B.UserId

I think almost all hear mistakes here as mentioning it as sql query.So lets see how it is done in linq from these..
http://www.dotnet-tricks.com/Tutorial/linq/UXPF181012-SQL-Joins-with-C[^]
how to join two tables using linq query[^]
http://stackoverflow.com/questions/611074/linq-joining-two-tables[^]
http://social.msdn.microsoft.com/Forums/en-US/csharpgeneral/thread/370d7296-5289-430a-a26a-50614fde187a[^]

Try this:

var result = from a in TableA.AsEnumerable()
            join b in TableB.AsEnumerable() on a.Field<string>("Userid") equals 
            a.Field<string>("Userid")
            select new
            {
               TempId = a.Field<string>("TempId"),
               Email = a.Field<string>("Email"),
               PhoneNo = a.Field<string>("PhoneNo"),
               Userid= a.Field<string>("Userid"),
               Name = b.Field<string>("Name"),
            };

--Amit

Hi Friends,

I Solved this by myself, thanks for your research and answers,

here is the query that I used

var query = (from A in context.ATable
join B in Context.BTable on A.UserId equals B.UserId
where ((A.UserId != userID)
select new { A.TempId,A.Email, A.PhoneNo,B.Username });

Thanks,
RK

SELECT * FROM A INNER JOIN B on A.userid=B.Userid