It isn't clear to me which part of your query is the product id, but if simplicity is your goal, you could leave that query as it is, then do a query of queries and just do a SELECT DISTINCT on which ever columns have your product info.
More generally, if you want the product info but not the images, then just don't join over to the images table. I am not entirely sure which table has your product info but just select the product info from there and you should be ok. Judah On Sat, Mar 7, 2009 at 4:52 PM, Jason Congerton <ja...@jasoncongerton.co.uk> wrote: > > 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:320215 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4