No, you don't need to iterate or use temporary tables. All you need is a fairly simple GROUP BY query. Please give it a try, and post back if you come up against any particular problems. If you do so, please supply sample data and DDL in the way described in the second link in Anthony's signature above.

John