title: ASP.Net C# - Datalist Not Complex Enough - Adding Item Data From Secondary Tables
body: <p>I have a datalist that is generated from a database table with the query that is something like this.</p>
  
  <pre><code>SELECT Product_Type, Unit_Type, Image FROM Products WHERE ProductID = 1 Or ProductID = 2 OR ProductID = 3... etc.
  </code></pre>
  
  <p>I want to display a pie graph for each item in the datalist that would rely on data from another table for the chart.  The data in this secondary table can be selected with ProductID as well.</p>
  
  <p>My issue is that the datalist seems to be run from a single SELECT to a table.  Is there a way for me to instruct the datalist to retrieve supplemental data from a secondary table for EACH item in the datalist?</p>