CREATE TABLE PersonFriend (friend VARCHAR, name VARCHAR)
CREATE TABLE Person (name VARCHAR)

Who are the friends of Bob?
SELECT T2.friend FROM Person AS T1 JOIN PersonFriend AS T2 ON T1.name = T2.name WHERE T1.name = 'Bob'
SELECT "T2"."friend" FROM "Person" AS "T1" JOIN "PersonFriend" AS "T2" ON "T1"."name" = "T2"."name" WHERE "T1"."name" = 'Bob'