title: How to display the results of inner join query table in sqlite?
body: <p>So, I'm using C# winrt with SQLite database. I want to display the results of the query which i have "join"ed.</p>
  
  <p>I have 2 tables which are Student and Course.</p>
  
  <p>Student has : id(PK), name, courseid</p>
  
  <p>Course has : courseid(PK), coursename</p>
  
  <p>And here is my code :</p>
  
  <pre><code>        var query1 = conn.QueryAsync&lt;Student&gt;("select * from Student s inner Join Course c on s.courseid  = c.courseid");
          var query2 = conn.QueryAsync&lt;Course&gt;("select * from Course c inner join Student s on c.courseid = s.courseid");
          var result1 = await query1;
          var result2 = await query2;
          lstJoin.Items.Clear();
          foreach (var item in result1)
          {
              string text = "Name: " + item.name + ", Course Id: " + item.courseid + ", Course Name : " + item.coursename;
              lstJoin.Items.Add(text);
          }
  </code></pre>
  
  <p>But the "item.coursename" is error, so i can't display it. And then, if I change result1 in foreach with result 2, "item.name" will be error. What should I do so I can display both of them? Thank you.</p>