>Hi everybody,
>
>Why these two would return different results?
>

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