Re: [PHP] concat and join stuff

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 con

[PHP] concat and join stuff

Here some code that works fine, but... "SELECT b.*, c.publisher, CONCAT_WS(' ', first_name, last_name) AS Author FROM book AS b LEFT JOIN book_publisher as abc ON b.id = abc.bookID LEFT JOIN publishers AS c ON abc.publishers_id = c.id LEFT JOIN book_author AS