> When what I need is this: > > ItemY - 1 - 1 > ItemY - 2 - 3 > ItemZ - 1 - 2 > ItemZ - 2 - 1 > ItemX - 1 - 2 > ItemX - 2 - 2
I think the key is what factor(s) determines why ItemY is ordered before ItemZ and ItemX. Because without that part, it is just a simple ORDER BY Item, Sort1, Sort2. Which would probably give you: ItemX - 1 - 2 ItemX - 2 - 2 ItemY - 1 - 1 ItemY - 2 - 3 ItemZ - 1 - 2 ItemZ - 2 - 1 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/sql/message.cfm/messageid:3269 Subscription: http://www.houseoffusion.com/groups/sql/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.6
