Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Shaun E on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: Greencoffee
- Content: Threads
- Order by date
-
Finding the lowest sum (FIFO)
I have different quantities of product in different bins. Ultimatley I need to display the bin with the least amount of product. The quantity of product 'X' in a particular bin will be summed. So it will look like this: Bin Prod QOH A1 X 15 <--this is computed in the query using sum() A2...- Greencoffee
- Thread
- Replies: 12
- Forum: ANSI_SQL
