i think i got this solved; sorry about the non-php question but there
isn't a mysql newsgroup that i know of.
Matthew Crouch wrote:
> 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
> 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?
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php