Many-to-Many showing one row per record

To simplify, I have 3 tables:

article
id title

author
id name

art_auth
artid authid

I would like the results to be displayed as follows (every title showing all the authors):
title name1 name2 name3....

Is there any query that can be executed to show this result set?

SELECT article.title, author.name FROM article, author, art_auth WHERE article.id=art_auth.artid AND author.id=art_auth.authid

Thanks, I think I need to clarify.

The result of the query provided would be:

1. title1 authorname1
2. title1 authorname2
3. title1 authorname3

Unfortunately, I want something a little more complex and I'm not even sure if there is an SQL query is capable of this output.

I would like the row to display all the authors related to the one title.

so if there are 3 authors in the intermediate table that the row would show:

title1 authorname1 authorname2 authorname3

Any assistance would be greatly appreciated!!!

I see what you mean... I may be wrong, but I don't think you can do that from SQL alone. I would use your programming language to loop through the resultset and customize the output

Hint, add an order by clause to my query above and you'll be able to lump each article title together.

I know it's not the answer you're looking for, and I encourage anyone else to correct me, but I'm almost positive there's no other way.