>>ID and SITE will always have unique values.... no duplicates allowed.
Ok, but you still have to list all columns in your SELECT list, it is a matter of SQL syntax, not logic. In pure logic, a "GROUP" clause should be enough, since one has no choice, but this is the way SQL has been designed. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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/cf-talk/message.cfm/messageid:323522 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
