[thelist] SQL to get combo that sums to amount

[aspscript at canada.com]

I have a table where each record has a field called
"quantity" with an integer value.  How would I
construct a query that searches thru hundreds of
records and determines what combination of those
records has a sum of the quantities that equals 50?

Any help or clues as to how to get started appreciated.