This should work. No sub-selects needed here. select a.people_name, b.people_name as people_friend_name from people a, people b where a.people_friend_ID=b.people_ID
Remi Mikalsen E-Mail: [EMAIL PROTECTED] URL: http://www.iMikalsen.com On 7 Oct 2004 at 10:34, Ronan Lucio wrote: > 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] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
