question about SQL query and cfoutput with INNER JOIN

[nedflanders]

I have a query that pulls data from two related tables (an Article Table and a
Photo table, linked by ArticleID) Lets say i have 3 photos that are related to
aricleID 1 (articleid is unique and there is only one article with that ID).
when i run the query i get 3 rows returned, this is becuase there is 3 photos.
Now, i want to output that data in a cfoutput but when i do i get 3 records
written to the page. My questions is; how do i supress the article from being
output 3 times but allow me to output all 3 associated photos?

Hope this makes sense
thanks!
nf

Sample Query
SELECT Articles_MyGVegas.ArticleID, Articles_Photo.PhotoID,
Articles_Photo.Photo_Name, Articles_MyGVegas.Headline
FROM Articles_MyGVegas INNER JOIN
Articles_Photo ON Articles_MyGVegas.ArticleID =
Articles_Photo.ArticleID

Output
articleID headline photoid
1 test 6
1 test 7
1 test 8

[rmorgan]

Have you tried the grouping attribute for cfoutput? that may work.

[nedflanders]

alright, thats it.
Thanks!