Thankyou, That worked a treat! Thankyou so very much -- David Scott
----- Original Message ----- From: "Michael Stassen" <[EMAIL PROTECTED]>
To: "Critters" <[EMAIL PROTECTED]>
Cc: <mysql@lists.mysql.com>
Sent: Tuesday, May 17, 2005 5:01 PM
Subject: Re: A question of joining...
Critters wrote:Hi, I am having problems with the JOIN function.
MESSAGES memberID_1, memberID_2, Message
MEMBERS id, name
I can only manage to replace the "memberID_1" in MESSAGES with the "name" in MEMBERS, I can not replace both memberID_1 and memberID_2 with "name".
Please can someone tell me what I should be looking for in the help documents.
--
David Scott
You need a join for each lookup. Something like:
SELECT mem1.name, mem2.name, mess.Message FROM messages mess JOIN members mem1 ON mess.memberID_1 = mem1.id JOIN members mem2 ON mess.memberID_2 = mem2.id WHERE ...;
If it is possible that either memberID_1 or memberID_2 is NULL, or doesn't point to a valid member row, then you should replace "JOIN" with "LEFT JOIN".
Michael
--
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]
