<div>
you can try something like this...<br />
<br />

<pre><code class="code-1 nolinks" id="code-20-36149457-1"><span>SELECT     a.field1, COUNT(*) AS Cnt</span>
<span>FROM         ParentTable AS a INNER JOIN</span>
<span>                      ChildTable AS b ON a.field1 = b.field1</span>
<span>GROUP BY a.field1</span>
<span>HAVING      (COUNT(*) &gt; 1)</span>
</code></pre>
</div>


<div>
<div class="content wysiwyg-content">
I have two tables that are related. I would like to write a query that returns only those rows that have more than one related record in the child table. <br />
<br />

</div>
</div>


I have two tables that are related. I would like to write a query that returns only those rows that have more than one related record in the child table. 



How to return only those rows in a related table where there are more than one related row

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.