This select will fail because of the "group by TYPEofObject". As the reference is not to a column name but to an alias, it should be placed between ""
A more complete statement could look like Select str$(obj) "TypeofObject", count(*) "Qty" from <table_name> group by "TypeofObject" order by "Qty" desc into sele Browse from sele One can also get the contents of the first column, first record of Sele as the answer to the original question : What is the dominant object type? Jacques Paris -----Original Message----- From: Lawley, Russell S [mailto:[EMAIL PROTECTED]] Sent: November 29, 2002 09:36 To: 'Lars V. Nielsen'; [EMAIL PROTECTED] Subject: RE: MI-L Dominant feature type ? Lars I always use teh following sql Select Count(*),str$(obj)"TYPEofOBJECT" from THE_TABLE group by TYPEofOBJECT into Selection Browse * From Selection HTH Russell Lawley Brit. Geol. Surv. ********************************************************************* This e-mail message, and any files transmitted with it, are confidential and intended solely for the use of the addressee. If this message was not addressed to you, you have received it in error and any copying, distribution or other use of any part of it is strictly prohibited. Any views or opinions presented are solely those of the sender and do not necessarily represent those of the British Geological Survey. The security of e-mail communication cannot be guaranteed and the BGS accepts no liability for claims arising as a result of the use of this medium to transmit from or to the BGS. The BGS cannot accept any responsibility for viruses, so please scan all attachments. http://www.bgs.ac.uk ********************************************************************* --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 4353 --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 4354
