vb.net datagridview display from 2 tables
<p>I am using visual studio, and I am having trouble with datagridview, can I display a query that joins two tables in this datagridview?</p>

<p>For example, I already asked in here about the query that I have to try on merging two tables,</p>

<pre><code>goods
id | name
1  | coffee
2  | tea
3  | choco
</code></pre>

<p>and</p>

<pre><code>total
goodsID | quantity
3       | 40
2       | 20
1       | 10
</code></pre>

<p>and the display i want to see in the datagridview is</p>

<pre><code>total
goods | quantity
choco | 40
tea   | 20
coffee| 10
</code></pre>

<p>I already searched on what query to use but when i add a query in the datagridview, I get an error saying "The schema returned by the new query differs from the base query". Is there anyway to fix this? Please help me, im trying to make a simple/practice vb forms program.</p>