mysql joining 101
| From: | Matthew Crouch | Date: | Sun, 31 Mar 2002 06:42:45 +0000 |
| Subject: | mysql joining 101 | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-18074@lists.php.net to get a copy of this message | ||
Here's an easy one that I can't find laid out for me anywhere:
I want a self join that pairs up the id numbers of a table in every
permutation
e.g. i have id #s 1, 2, and 3
i need this result:
1 2
1 3
2 1
2 3
3 2
3 1
clear enough?