Check_user.txt
| 1 |
SELECT A.TLNANME,A.TLFullName,B.BRANCH_NAME,b.BRANCH_CODE,C.DEP_NAME,c.DEP_CODE,E.DisplayName,E.[Desc] |
|---|---|
| 2 |
FROM TL_USER A |
| 3 |
LEFT JOIN CM_BRANCH B ON A.TLSUBBRID = B.BRANCH_ID |
| 4 |
LEFT JOIN CM_DEPARTMENT C ON A.DEP_ID = C.DEP_ID |
| 5 |
LEFT JOIN AbpUserRoles D ON A.ID = D.UserId |
| 6 |
LEFT JOIN AbpRoles E ON D.RoleId = E.Id |
| 7 |
WHERE A.TLSUBBRID <> 'DV0001' |
| 8 |
ORDER BY B.BRANCH_NAME,C.DEP_NAME |