HERE IS AN SQL PUZZLE - Please Help
| From: | Jingle Balls | Date: | Sun, 15 Oct 2000 15:08:14 +0000 |
| Subject: | HERE IS AN SQL PUZZLE - Please Help | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-20242@lists.php.net to get a copy of this message | ||
My brain doesnt want to work right now:
Two Tables
table_a:
id | name
1 | chris
2 | paul
table_b:
id | table_a_name | buddy_name | comment
1 | 2 | 1 | friend
2 | 1 | 2 | whatever
what is the sql statement that will return:
table_b.id | table_a.name as user | table_a.name as buddy | comment
1 | paul | chris
| friend
2 | chris | paul
| whatever
I know I must be missing something.
Thanks
--
http://www.LASTJEDI.ORG
The end is near...................