Select Code to Download

CREATE TABLE person (
    id   INTEGER NOT NULL,
...
    friend INTEGER NOT NULL,
    PRIMARY KEY ( person, friend )
);

INSERT INTO person VALUES ( 1, 'Al' );
INSERT INTO person VALUES ( 2, 'Bob' );
...
INSERT INTO friend VALUES ( 8, 7 );
INSERT INTO friend VALUES ( 9, 1 );
INSERT INTO friend VALUES ( 9, 7 );

sqlite> SELECT P1.name, P2.name                              
   ...> FROM person P1 
...
Bob|Al
Bob|Doug
Bob|Gary

sqlite> SELECT P1.name, P2.name
   ...> FROM person P1
...
Gary|Bob
Gary|Hamza
Gary|Ibrahim

sqlite> SELECT P1.name, P2.name
   ...> FROM person P1
...
Hamza|Gary
Ibrahim|Al
Ibrahim|Gary