how to use inner join in linq query

Hi,
Please refer the links:
http://stackoverflow.com/questions/525194/linq-inner-join-vs-left-join[^]
http://msdn.microsoft.com/en-us/library/bb397941.aspx[^]
http://msdn.microsoft.com/en-us/library/bb397676.aspx[^]


All the best.
--AK

Please refer:
LINQ TO ENTITIES – JOIN QUERIES[^]
Inner, Outer, All Join With LINQ[^]

var hp = from p in db.table_name1 join m in db.table_name2 on p.id equals m.o_id select new
{ Name = p.name, Order = m.order_name };
GridView1.DataSource=hp;
GridView1.DataBind();

Quote:

http://seesharpconcepts.blogspot.in/2012/08/performing-inner-join-and-left-outer.html[^]

This is similar information that you find on MSDN and StackOverFlow, but with a simple example and explanation.

from st in obj.Cart_tables
                                 join x in obj.movie_details on st.movie_id equals x.Id
                                 where st.username == Session["user"].ToString()
                                 select new{x.items,st.items}