>SELECT COUNT(cTrans_pk) FROM Trans ; >INNER JOIN trans_Employees_Queues ON Trans.ctrans_pk = Trans_Employees_Queues.ctrans_fk AND ; > Trans_Employees_Queues.iactive_flag = 1 ; >WHERE Trans.cResolution_Codes_Fk is NUll > >SELECT COUNT(cTrans_pk) FROM Queue_Names ; >INNER JOIN trans_Employees_Queues ON Queue_Names.cQueue_Names_pk=Trans_Employees_Queues.cQueue_Names_fk ; > INNER JOIN Trans ON Trans.ctrans_pk = Trans_Employees_Queues.ctrans_fk ; > AND Trans_Employees_Queues.iactive_flag = 1 ; >WHERE Trans.cResolution_Codes_Fk is NUll >Ok, I found that SELECT * FROM Trans_Employees_Queues WHERE cQueue_Names_fk NOT in (SELECT cQueue_Names_pk FROM Queue_Names) returns 826 records. So our last data load has a problem, which explains the difference in my statistical results.