<div>
WHERE T2.count_t2 &gt;&nbsp;T1.count_t1 
OR T1.count_t1 IS NULL 
OR T2.count_t1 IS NULL 
 
it may need to cater for NULLs which I forgot
</div>

WHERE T2.count_t2 > T1.count_t1
OR T1.count_t1 IS NULL
OR T2.count_t1 IS NULL

it may need to cater for NULLs which I forgot

<div>
<div class="content wysiwyg-content">
I need to compare Table_1 and Table_2. 
 
Table_1 and Table_2 both have duplicate records. Table_2 has more duplicate records in it than table_1. 
I need a list of all of the names in table_2 that are also in table_1. But I want the names of those in Table_2 
that have more duplicate names in table_2. So for example, below both tables have Joseph Dreadson in them. 
 
 
Table_2 has more records in it than Table_1. 
 
I need a list of all of the names in Table_2 that have more records than their matching names in 
Table_1. 
 
 
So for these two tables : 
 
 
Table_1 
FNAME &nbsp; LNAME 
Bob &nbsp; &nbsp; Candoiti 
Mary &nbsp; &nbsp;Semper 
Mary &nbsp; &nbsp;Semper 
Mary &nbsp; &nbsp;Semper 
Joseph &nbsp;Dreadson 
Terry &nbsp; James 
 
 
 
 
Table_2 
FNAME &nbsp; LNAME 
Bob &nbsp; &nbsp; Candoiti 
Mary &nbsp; &nbsp;Semper 
Mary &nbsp; &nbsp;Semper 
Joseph &nbsp;Dreadson 
Joseph &nbsp;Dreadson 
Joseph &nbsp;Dreadson 
Terry &nbsp; James 
Terry &nbsp; James 
 
 
 
So the desired query would return these two records, because these people occur more frequently in table_2 than table_1 
&nbsp;: 
 
Joseph Deadson 
Terry &nbsp;James
</div>
</div>

I need to compare Table_1 and Table_2.

Table_1 and Table_2 both have duplicate records. Table_2 has more duplicate records in it than table_1.
I need a list of all of the names in table_2 that are also in table_1. But I want the names of those in Table_2
that have more duplicate names in table_2. So for example, below both tables have Joseph Dreadson in them.


Table_2 has more records in it than Table_1.

I need a list of all of the names in Table_2 that have more records than their matching names in
Table_1.


So for these two tables :


Table_1
FNAME   LNAME
Bob     Candoiti
Mary    Semper
Mary    Semper
Mary    Semper
Joseph  Dreadson
Terry   James




Table_2
FNAME   LNAME
Bob     Candoiti
Mary    Semper
Mary    Semper
Joseph  Dreadson
Joseph  Dreadson
Joseph  Dreadson
Terry   James
Terry   James



So the desired query would return these two records, because these people occur more frequently in table_2 than table_1
 :

Joseph Deadson
Terry  James

help with tricky query.

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.