Thanks for your responses Sorry for my lack of question!!
The query grabs a product and its images, I only need to display products in the list I.e product 1, product 2, product 3 etc. At the moment the query will display product 1, product 1 etc for every picture it has, which I know is correct. Although my earlier posted query did not show it I had already tried order by and the group variable in cfoutput query. Which is normally how I would do this, but its not working, I do not even get a true representation of the images in the right table I.e if product 1 has four images, it may not necessarily display 4 times. I will have a poke around and post back. Jason ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320214 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
