title: ViewBag select list LINQ table join
body: <p>Is it possible to join tables in a SelectList?</p>
  
  <p>Here is what I have:</p>
  
  <pre><code>ViewBag.Clients = new SelectList(db.IPACS_Clients, "clientID", "name", 0);
  </code></pre>
  
  <p>I need to join the db.IPACS_Clients_Network table, I still need "clientID" but for "name" I need to be able to select IPACS_Clients.name + " - " + IPACS_Clients_Network.name</p>
  
  <p>Is this possible with a Viewbag?</p>