I've given up on the LEFT JOIN thing I was poking at earlier, and have successfully (at least at a mysql command prompt) designed the necessary sequence of commands to get what I want ... in the form of a "CREATE TEMPORARY TABLE" follow by two "INSERT INTO ... SELECT"s.
The only catch is ... it won't go in PHP. The code looks fine, and I suspect it's just a permission problem. Do I *realy* need database CREATE permission on the db server even to create TEMPORARY tables? Or would I be ahead to simply slurp all the data into an array in PHP and sort it there? Or is it worthwhile/safe at this point to upgrade to MySQL v4 on a production system? Tnx. -- Paul Chvostek <[EMAIL PROTECTED]> Operations / Development / Abuse / Whatever vox: +1 416 598-0000 IT Canada http://www.it.ca/ --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php