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

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


you can try something like this...



SELECT     a.field1, COUNT(*) AS Cnt
FROM         ParentTable AS a INNER JOIN
                      ChildTable AS b ON a.field1 = b.field1
GROUP BY a.field1
HAVING      (COUNT(*) > 1)

<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.