One more correction: select CAST(nvl(Count(cTrans_pk),0)...

>See corrections inline
>
>>This still returns 3 records. What's wrong:
>>
>>

>>TEXT TO lcSQL NOSHOW PRETEXT 7
>>	SELECT CAST(NVL(COUNT(*), 0) as Numeric(5,0)) as nCount, ;
>>	Queue_Names.cQueue_Names_pk, Queue_Names.cQueue_Name,
>>	NVL(Trans.cDepartment_Code, Queue_Names.cDepartment_Code) as cDepartment_Code
>>	FROM Queue_Names
>>	LEFT JOIN Trans_Employees_Queues on
>>	Queue_Names.cQueue_Names_pk = Trans_Employees_Queues.cQueue_Names_fk
>             AND Trans_Employees_Queues.iActive_Flag = 1
>>	LEFT JOIN Trans on Trans.cTrans_pk = Trans_Employees_Queues.cTrans_fk	
>	where Queue_Names.iActive_Flag = 1
>>	group by 2,3,4
>>ENDTEXT

>>