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?
SELECT p1.people_name,p2.people_name FROM People p1 LEFT JOIN People p2 ON (p2.people_ID = p1.people_friend_ID);
-m -- ## Mark T. Dame <mailto:[EMAIL PROTECTED]> ## VP, Product Development ## MFM Communication Software (http://www.mfm.com/) "When I'm with you I don't know whether I should study neurosurgery or go to see the Care Bears Movie." -- "Weird Al" Yankovic, "You Make Me"
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
