Re: HERE IS AN SQL PUZZLE - Please Help
| From: | Zipkid | Date: | Sun, 15 Oct 2000 15:35:16 +0000 |
| Subject: | Re: HERE IS AN SQL PUZZLE - Please Help | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-20244@lists.php.net to get a copy of this message | ||
Jingle Balls wrote:
>
> 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
SELECT b.id AS id, a1.name as user, a2.name as buddy, comment
FROM table_b b LEFT JOIN table_a a1 ON b.table_a_name = a1.id
LEFT JOIN table_a a2 ON buddy_name.id = a1.id
Is this what you are looking for??
--
Stefan - Zipkid - Goethals
YourNet - Open source web design & Site management.
http://www.yournet.be
mailto:stefan@yournet.be