>>SELECT DISTINCT padr(PROPER(ALLTRIM(Employees.cEmployee_first_name) + SPACE(1) + ; >> Employees.cEmployee_last_name), 50) AS cEmpName, ; >> Users.cUserID, Usgrlink.cUsgrlink_pk ; >> FROM Users INNER JOIN USGRLINK ; >> ON Users.iID = Usgrlink.iUserID ; >> INNER JOIN EMPLOYEE_TEAMS ; >> ON Employee_teams.cEmployee_teams_pk = Usgrlink.cEmployee_teams_fk ; >> INNER JOIN EMPLOYEES ; >> ON Users.cUsers_pk = Employees.cUsers_fk ; >> INNER JOIN Departments on Employee_teams.cDepartments_fk = Departments.cDepartments_pk ; >> UNION ; >> SELECT SPACE(50) as cEmpName, SPACE(10) as cUserID, CAST(null as C(16) NULL) as cUsGrLink_pk FROM Users>The questio you should ask is not if it'll work but how efficient it'll be.