title: Using LINQ to get information from two tables, with a join
body: <p>I have a linq statement to populate two labels. The thing is, this information comes from two tables. I Have a join to join the two tables, except i cant get my Terms and Conditions from my Campaign table. Its only picking up the RedemptionLog table columns. Anyone to help with this?</p>
  
  <pre><code>MSCDatabaseDataContext MSCDB = new MSCDatabaseDataContext();
              var q = from row in MSCDB.Tbl_RedemptionLogs 
                      join d in MSCDB.Tbl_Campaigns on row.CampaignId equals d.CampaignId
                      orderby row.VoucherCode descending
                      select row;
  
              var SeshVoucherDisplay = q.First();
  
              lblCode.Text = SeshVoucherDisplay.VoucherCode;
              lblTerms.Text = SeshVoucherDisplay
  </code></pre>
  
  <p>For the SeshVoucherDisplay variable, it only picks up from the RedemptionLogs table, yet i did a join? Any help? </p>