> Just out of curiosity, since I've only casually been following > this thread, was there a specific reason for the "group by" > clause? > > I think what is desired is simplly an "order by" clause, e.g. Well, I'm really confused now. I came up with my own version of the query: select distinct volume_name,stgpool_name from volumeusage where node_name='FOO' and that produces an answer: VOLUME_NAME STGPOOL_NAME ------------------ ------------------ ITF010 CPITFPOOL ITF013 CPITFPOOL ITF018 CPITFPOOL ITF026 CPITFPOOL ITF001 ITFPOOL ITF003 ITFPOOL ITF004 ITFPOOL ITF014 ITFPOOL ITF025 ITFPOOL ITF027 ITFPOOL ITF028 CPITFPOOL ITF006 ITFPOOL ITF002 CPITFPOOL BUT if I add "order by stgpool_name" it doesn't show all the tapes - eg: VOLUME_NAME STGPOOL_NAME ------------------ ------------------ ITF010 CPITFPOOL ITF001 ITFPOOL So what's going on here?
- Re: How to find out what tape's a client data are on ... Shekhar Dhotre
- Re: How to find out what tape's a client data are on ... Andy Raibeck
- Re: How to find out what tape's a client data are on ... ALAN DAVENPORT
- Re: How to find out what tape's a client data are on ... Allen Barth
- Re: How to find out what tape's a client data ar... Bernhard Unold
- Re: How to find out what tape's a client data are on ... David Longo
- Re: How to find out what tape's a client data are on ... Shekhar Dhotre
- Re: How to find out what tape's a client data are on ... David Longo
- Re: How to find out what tape's a client data are on ... Shekhar Dhotre
- Re: How to find out what tape's a client data ar... Thomas A. La Porte
- Re: How to find out what tape's a client data are on ... Walker, Lesley R
- Re: How to find out what tape's a client data are on ... Sharp, Neil (London)
- Re: How to find out what tape's a client data are on ... Steve Hicks
- Re: How to find out what tape's a client data ar... Bernhard Unold
- Re: How to find out what tape's a client data are on ... Andy Raibeck
- Re: How to find out what tape's a client data are on ... Prather, Wanda
- Re: How to find out what tape's a client data are on ... Walker, Lesley R