I use asp.net mvc... How to write an inner join in linq-to-sql for this sql query select M.Mat_id,M.Mat_Name,T.Name as Measurement,M.Mat_Type as Description