Do you have a question? Post it now! No Registration Necessary. Now with pictures!
- * Tong *
July 13, 2005, 7:00 pm
rate this thread
only to 1.
How can I do this:
select g_name from goods order by g_priority where sum(g_value) < 500
I.e., I want to orderly pick from table goods so that the total picked
value is less than a defined value.
Certainly the above sql won't work (tested under mysql). How can I do it?
Tong (remove underscore(s) to reply)
*niX Power Tools Project: http://xpt.sourceforge.net /
- All free contribution & collection
- » Americanas.com SALDO de TVs Com at 80% de Desconto (29798)
- — Newest thread in » MySQL Database Forum