Your are right, it is better to use quotes. But the problem with the group by isn't solved. Regards Stefan Holzwarth
-----Ursprüngliche Nachricht----- Von: Paul Miller [mailto:Paul_Miller@;CARGILL.COM] Gesendet: Donnerstag, 24. Oktober 2002 15:44 An: [EMAIL PROTECTED] Betreff: Re: Group by problem for Storagereports Shouldn't you group by "SERVERTYP"? I think you need the quotes. Paul Miller -----Original Message----- From: [EMAIL PROTECTED] [mailto:stefan.holzwarth@;ADAC.DE] Sent: Thursday, October 24, 2002 7:19 AM To: [EMAIL PROTECTED] Subject: Group by problem for Storagereports Hello, i tried to realize some storage reports about out NT servers with the following select: select substr(nodes.contact,1,1) as SERVERTYP ,sum (filespaces.capacity), - sum (filespaces.capacity*pct_util/100) from nodes,filespaces where filespace_name like '%\c$' and nodes.node_name=filespaces.node_name group by SERVERTYP But: === ANR2940E The reference 'SERVERTYP' is an unknown SQL column name. | ......................................................V........ c$' and nodes.node_name=filespaces.node_name group by SERVERTYP Any ideas who to group by the first letter of the description? (I use the first letter for asigning the Server to some goups like mail, application, file,.....) Kind regards, Stefan Holzwarth ------------------------------------------------------------------------ ---- -- Stefan Holzwarth ADAC e.V. (Informationsverarbeitung - Systemtechnik - Basisdienste) Am Westpark 8, 81373 München, Tel.: (089) 7676-5212, Fax: (089) 76768924 mailto:stefan.holzwarth@;adac.de
