title: How to get Values of another table using one table using LINQ
body: <p>I've Three tables <code>Master</code>,<code>Users</code>,<code>Category</code> like below</p>
  <pre><code>  Master Table :                                Users Table :     Category Table :
  +---+------------+-----------+------------+     +----+------+    +----+-------+
  |ID | CategoryID | CreatedBy | UpdatedBy  |     | ID | Name |    | ID | Name  |
  +---+------------+-----------+------------+     +----+------+    +----+-------+
  | 1 |    1       |    1      |     1      |     | 1  | Ravi |    |  1 | Fruit |
  | 2 |    2       |    2      |     1      |     | 2  | Balu |    |  2 | Toys  |
  | 3 |    2       |    2      |     2      |     +----+------+    +----+-------+
  +---+------------+-----------+------------+ 
  </code></pre>
  <p>In <strong>Master</strong> table <code>CretedBy</code> and <code>UpdatedBy</code> id's are referenced to <strong>Users</strong> table. I wrote the LINQ to get the data from <strong>Users</strong> and <strong>Category</strong> tables like below :</p>
  <pre><code>var result = (from p in db.Master join q in db.Category on p.CategoryID equals q.ID join r in db.Users on p.CreatedBy equals r.ID select new {p,q,r}).ToList();
  </code></pre>
  <p>From Here i can able to get the <code>CreatedBy</code> value from <strong>Users</strong> table. But, also how to get the value of <code>UpdatedBy</code> from <strong>Users</strong> table using LINQ?</p>
  <p>Can you please help me?</p>
  <p>Thanks in Advance !!!!!</p>