RE: SQL Help Requested: Unique Same Field Sum Combinations

2003-02-13 Thread Peter Bagnato
: Unique Same Field Sum Combinations Thomas Sammons wrote: > > How would you do this in CF (any version 4.5 or higher): return all > unique combinations of rows where the unique row field value > combination has a certain summed value? > > For example: > I have a SocksTab

Re: SQL Help Requested: Unique Same Field Sum Combinations

2003-02-13 Thread Jochem van Dieten
Thomas Sammons wrote: > > How would you do this in CF (any version 4.5 or higher): return all > unique combinations of rows where the unique row field value combination > has a certain summed value? > > For example: > I have a SocksTable with 6 SockDrawers, and each SockDrawer has a number > of S

SQL Help Requested: Unique Same Field Sum Combinations

2003-02-13 Thread Thomas Sammons
Hiho, I've posted this at the cf dev support forums but haven't gotten any replies, so I thought I'd try here (where all the really smart people are :-) How would you do this in CF (any version 4.5 or higher): return all unique combinations of rows where the unique row field value combination h