Is this kind of ORDER BY possible?

Let's say that I have the following dataset after an INNER JOIN query: UserName | InventoryItem | InventoryAmount | - | --- Joe | Hammer | 2 Joe | Nails | 7 Joe | Screws | 9 Bob | Hammer | 1 Bob |

Re: Is this kind of ORDER BY possible?

I don't think you can order on a certain condition within a query. You can do this with a stored procedure though ... Or, but that would require some logic in the app, with views Greets Olaf On 11/5/07 10:55 AM, Christoph Boget [EMAIL PROTECTED] wrote: Let's say that I have the following

Re: Is this kind of ORDER BY possible?

Christoph, Christoph Boget wrote: Let's say that I have the following dataset after an INNER JOIN query: UserName | InventoryItem | InventoryAmount | - | --- Joe | Hammer | 2 Joe | Nails | 7 Joe | Screws | 9 Bob