title: how to include some data in 2 tables asp.net mvc 4
body: <p>Sorry for my bad English..</p>
  
  <p>I have 3 tables, like this.. I use ViewModel</p>
  
  <pre><code>public class CostumVM
  {
      public rol_tb_form1 rol_tb_form1 { get; set; }
      public tb_update_status_moc tb_update_status_moc { get; set; }
      public rol_tb_ramanalysis rol_tb_ramanalysis { get; set; }
  }
  </code></pre>
  
  <p>in that table I joined them with this code</p>
  
  <pre><code>public ActionResult UpdateEmoc()
      {
  
          var updateemoc = from a in db.rol_tb_form1
                           join b in db.tb_update_status_moc on a.no_mocx equals b.no_mocx
                           join c in db.rol_tb_ramanalysis on a.id_ram equals c.id
                           select new CostumVM { rol_tb_form1 = a, tb_update_status_moc = b, rol_tb_ramanalysis = c};
  
          return View(updateemoc);
      }
  </code></pre>
  
  <p>but, I have a problem, data in table <em>rol_tb_form1</em> and <em>rol_tb_update_status_moc</em> is 300++, but data in <em>rol_tb_ramanalysis</em> just 7, if I use join so in view just show 7 data. I need to show 300++ in table <em>rol_tb_form1</em> and include 7 data betwen table <em>rol_tb_form1</em>..</p>
  
  <p>can someone help me?</p>