sqlite> SELECT P1.name, P2.name                              
   ...> FROM person P1 
   ...> JOIN friend F ON P1.id = F.person 
   ...> JOIN person P2 ON F.friend = P2.id 
   ...> WHERE P1.name = 'Bob' ;
P1.name|P2.name
Bob|Al
Bob|Doug
Bob|Gary