great. and who are Zach's friends?
SELECT * FROM Person AS T1 JOIN PersonFriend AS T2 ON T1.name   =   T2.name WHERE T2.friend   =   'Zach'
Zach's friends refers to the names of people who are listed as friends of Zach in the PersonFriend table;