Just a tiny comment: The Count aggregation always take a * as parameter, so you query should be like this:
Select WARD_NO, TENURE_TYPE, Count(*) "How_Many" >From MY_TABLE GROUP BY WARD_NO, TENURE_TYPE ORDER BY WARD_NO, TENURE_TYPE Into RESULTS_TABLE Peter Horsb�ll M�ller GIS Developer Geographical Information & IT COWI A/S Odensevej 95 DK-5260 Odense S Denmark Tel +45 6311 4900 Direct +45 6311 4908 Mob +45 5156 1045 Fax +45 6311 4949 E-mail [EMAIL PROTECTED] http://www.cowi.dk *****CHANGE OF ADDRESS - COWI's offices in Odense are now under the same roof***** On December 8th. 2003, Geographical Information & IT moved from Rugaardsvej 55, 5000 Odense C to Odensevej 95, 5260 Odense S. Please note our new telephone, direct and telefax numbers. > -----Original Message----- > From: Steve Kalmbach [mailto:[EMAIL PROTECTED] > Sent: Wednesday, January 14, 2004 7:38 PM > To: [EMAIL PROTECTED]; > [EMAIL PROTECTED] > Subject: Re: MI-L SQL Query > > > Yes, the query would go something like this: > > Select WARD_NO, TENURE_TYPE, Count(TENTURE_TYPE) "How_Many" > From MY_TABLE GROUP BY WARD_NO, TENURE_TYPE ORDER BY WARD_NO, > TENURE_TYPE Into RESULTS_TABLE > > If you are using the SQL select dialog, the first line above > is the 'Select Columns', the second line is the 'from > Tables', the third line is the 'Group by Columns', and the > fourth line is the 'Order by Columns'. > > > Steve Kalmbach > Systems Department > The Grand Rapids Press > 616-222-5498 > [EMAIL PROTECTED] > > > >>> "Andrew Tracey" <[EMAIL PROTECTED]> 01/14/2004 > 11:50:06 AM >>> > Dear All > > I have a MapInfo table which comprises ward reference no and > tenure type. I am trying to produce a query that will list > the 20 wards and a count of how many of each tenure type > there are in each ward. I want one browser with all results > on. Is this possible. > > Thanks in advance > Andrew Tracey > Information Support Officer > Corporate Information > Corporate Growth and Focus > Corporate Development > South Tyneside Council > Westoe Road > South Shields > NE33 2RL > > Tel: 0191 4247561 > E-Mail : [EMAIL PROTECTED] > ************************************************************** > ********************************** > Please do not print this e-mail if you can help it - and help > protect the environment. > ************************************************************** > ********************************** > This Message may contain confidential information and is > protected by copyright. If you receive it in error please > notify us and delete it without making use of or copying it. > The addressee and other employees within the Council may read > and copy any e-mail reply to this message and other e-mails > you send to us. Whilst we use virus checking procedures we > accept no liability for viruses and recipients > must rely on their own virus checking procedures. > ************************************************************** > ********************************** > The Council's web site address is www.southtyneside.info > > --------------------------------------------------------------------- > List hosting provided by Directions Magazine | > www.directionsmag.com | To unsubscribe, e-mail: > [EMAIL PROTECTED] > For additional commands, e-mail: > [EMAIL PROTECTED] > > Message number: 9883 > > > --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 9887
