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. ----- http://devshed.excudo.net http://devshed.excudo.net -- View this message in context: http://www.nabble.com/concat-and-join-stuff-tp22874340p22999438.html 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