 <p>First dataset add this SQL</p> <pre><code>Select ContryName, CountryID From Country </code></pre> <p>Assuming the name the above dataset's parameter is @country add the following SQL on the second dataset</p> <pre><code>Select RegionName, RegionID From Region Where CountryID IN( @country) </code></pre>