This is a self refering table by way of the SUPERV
field.

select P1.PIN, P1.LASTNAME, P1.SUPERV, P2.LASTNAME SUPER_LASTNAME
from PEOPLE P1 left join PEOPLE P2 on P1.SUPERV=P2.PIN

or

select PIN, LASTNAME, SUPERV,
(SELECT LASTNAME FROM PEOPLE P2 WHERE P2.PIN=P1.SUPERV) SUPER_LASTNAME
from PEOPLE P1

Daniel



[Non-text portions of this message have been removed]