>I beleive your cfoutput group should match the sort order of the query. >
I added the questionid to the front of the sort order. Still no luck. I did setup a valuelist so I could see what's coming straight out of the query. It produces this: Clinton,Clinton,Clinton,Clinton,Clinton,Bush,Bush,Bush,Bush,Bush,Reagan,Reagan,Reagan,Reagan,Reagan Computers,Projectors,Chalkboard,1,2,3,4,5,1,2,3,4,5,1,2,3,4,5 How am I getting a cartesian join?? I've double checked my join clauses. I need Clinton 1,2,3,4,5 Bush 1,2,3,4,5 Thanks, Will ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 & Flex 2 Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274819 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
