SELECT      dbo.DEPARTMENTS.NAME as Department, dbo.STAFF.LASTNAME AS Employee,
            StaffStatus=
            CASE dbo.STFDEPT.STATUS
            WHEN 'T' then 'Terminated'
            WHEN 'A' then 'Active'
            ELSE 'WARNING!!'
            END,
            dbo.USERS.USERNAME AS Desktop,
            DeskTopStatus=
            CASE dbo.USERS.ACTIVE
            WHEN 'T' then 'Active'
            WHEN 'F' then 'Inactive'
            ELSE ''
            END,
            dbo.MOBILEUSERS.USERNAME AS MOBUser,
            MobileStatus=
            CASE dbo.PORTALUSERS.APPROVED
            WHEN 'T' then 'Active'
            WHEN 'F' then 'Inactive'
            ELSE ''
            END
FROM   dbo.STAFF INNER JOIN
       dbo.STFDEPT ON dbo.STAFF.EMP_ID = dbo.STFDEPT.EMP_ID RIGHT OUTER JOIN
       dbo.DEPARTMENTS ON dbo.STFDEPT.DEPT_ID = dbo.DEPARTMENTS.DEPT_ID LEFT OUTER JOIN
       dbo.USERS ON dbo.DEPARTMENTS.DEPT_ID = dbo.USERS.DEFDEPT AND dbo.STAFF.EMP_ID = dbo.USERS.USER_ID LEFT OUTER JOIN
       dbo.PORTALUSERS ON dbo.STAFF.EMAILADDR = dbo.PORTALUSERS.EMAIL
         where dbo.STAFF.LASTNAME not like 'STAFF%'and dbo.STAFF.LASTNAME not like 'Admin%'
         order by 2,1