Some queries may need to refer to the same relation twice, we can give aliases to relation names to not have to write as much: (we can do the same to the projection)
SELECT E.FNAME AS EMPLOYEE_FNAME,
E.LNAME AS EMPLOYEE_LNAME,
S.FNAME,
S.LNAME
FROM EMPLOYEE E, EMPLOYEE S
WHERE E.SUPERSSN=S.SSN