Hi,

I have a situation like this:

Table People
=========
people_ID
people_name
people_friend_ID

people_friends_ID is the people_ID from another record.

Is there a way to make a SELECT that returns people_name
and people_friend_name?

Perhaps I´d get this with sub-selects but I´m using MySQL-4.0.18.

Any help would be appreciated.
Thanks,
Ronan



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to