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