How to filter a dataset with two datatables and a dataRelation? <p>I have two datatables in a dataset. The tables have the the same schema and a relationship on the item column. </p> <pre><code>Item | Qty </code></pre> <p>Now I would like to filter out only those rows where item number matches in both tables, but the qty doesn't. IN SQL I would do this:</p> <pre class="lang-sql prettyprint-override"><code>Select * from t1 inner join t2 on t1.item = t2.item and t1.qty &lt;&gt; t2.qty </code></pre> <p>I know I can filter single dataTable, but can I filter a dataset somehow?</p> <p>Update: The data does not come from SQL. </p>