---
title: "LINQ Inner Join"  
description: "LINQ Inner Join"  
author: "Norman Reedus"  
published: 2016-03-15  
updated: 2016-03-15  
canonical: https://www.mindstick.com/forum/34058/linq-inner-join  
category: "linq"  
tags: ["c#", "linq", "mvc"]  
reading_time: 1 minute  

---

# LINQ Inner Join

We want to use Inner [Join in linq](https://www.mindstick.com/forum/33665/how-to-use-join-in-linq-query-mvc) .how to write [inner join](https://www.mindstick.com/forum/33572/sql-inner-join-keyword) [query](https://www.mindstick.com/blog/202/sub-query-in-sqlserver) please help me.

## Replies

### Reply by Anonymous User

**[Join](https://www.mindstick.com/articles/1487/join-sleep-and-interrupt-methods-in-c-sharp-threading).**This is a keyword in [LINQ](https://www.mindstick.com/articles/12007/language-integrated-query-linq-queries). As with other query languages (such as SQL) joining matches every element in two collections based on some condition.

```
using System;using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Mvc;

namespace ForumMVC.Controllers
{
    public class HomeController : Controller
    {
        forumEntities context = new forumEntities();
        public ActionResult Index()
        {
            var q = (from pd in context.ProductStock
                     join od in context.ProductOrder on pd.ProductId equals od.ProductId
                     orderby od.OrderId
                     select new
                     {
                         od.OrderId,
                         pd.ProductId,
                         pd.ProductName,
                         od.OrderQty
                     }).ToList();

            return View();
        }
    }
}
```

![LINQ Inner Join](https://www.mindstick.com/mindstickforums/4ceb24be-91a1-4d35-84c8-f2b112a3dedf/images/3e481825-0d13-46be-8881-22296b21d176.png)


---

Original Source: https://www.mindstick.com/forum/34058/linq-inner-join

Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.