Some Notation
Attributes can be qualified
Tables can be renamed
SELECT S.FNAME, S.LNAME
FROM EMPLOYEE E, EMPLOYEE S
WHERE E.SUPERSSN = S.ESSN
SELECT * means display all columns
No WHERE means display all rows
Previous slide
Next slide
Back to first slide
View graphic version