Distinct?? Interesting.. why hadn't I thought of that :) Thanks Maya! No, actually I ended up solving it another way. I just added a few more keyIDs in the order by clause. It seemed to work even thought those fields were not appearing in the select statement. I'm posting here for anyone else having a similar problem.
And no, they're not real table names. I thought it wise to alias them on a public forum. And as for migrating from Access... yes.. a long term goal, certainly. But not really my decision at the moment. thanks anyway. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:3231 Subscription: http://www.houseoffusion.com/groups/sql/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.6
