Help using left outer joins in SQL...
- by Waffles
I'm trying to create a list of people, their friends, and their friends of friends.
My table of people is this:
People:
NAME
Jow
Smith
Sandy
Phil
Friends
LIKER LIKEE
jow smith
smith jow
sandy phil
Now, what I want is a table like this:
User Friend FriendofFriend
Jow smith jow
Smith jow smith
sandy phil
phil
I'm trying to create a…