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
If it's not broken, fix it until it is.
My Blog 
