How do you display data from two tables that are connected via an id?
<p>I have two tables with the following:</p>

<pre><code>table 1
sid, schedule, stime, splace, stourid

table 2
tourid, tourname
</code></pre>

<p>I want to display the <code>table 1</code> in a GridView, but with field <code>stourid</code> I want <code>tourname</code> from <code>table 2</code> to be displayed instead of <code>stourid</code>. How can I do this?</p>
