This is not really a PHP question, but a mysql question.
Anyways, your query should work, as far as i can see.
If you give the structure dumps and some relevant data dumps i don't mind to
give it a try here.
View this message in context:
Sent from the PHP - General mailing list archive at Nabble.com.
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php