SELECT A.TLNANME,A.TLFullName,B.BRANCH_NAME,b.BRANCH_CODE,C.DEP_NAME,c.DEP_CODE,E.DisplayName,E.[Desc]
FROM TL_USER A
LEFT JOIN CM_BRANCH B ON A.TLSUBBRID = B.BRANCH_ID
LEFT JOIN CM_DEPARTMENT C ON A.DEP_ID = C.DEP_ID
LEFT JOIN AbpUserRoles D ON A.ID = D.UserId
LEFT JOIN AbpRoles E ON D.RoleId = E.Id
WHERE A.TLSUBBRID <> 'DV0001'
ORDER BY B.BRANCH_NAME,C.DEP_NAME