Mailing List Archive


Back to the month index Back to the list index
Joshua J. Kugler (jkugler@inreach.com)
Wed, 12 Nov 1997 13:02:35 -0800 

Message-Id: <3.0.2.16.19971112130235.3cbf77fc@205.138.224.216>
Date: Wed, 12 Nov 1997 13:02:35 -0800
From: "Joshua J. Kugler" <jkugler@inreach.com>
Subject: Re: mSQL Support for groups?

At 10:29 AM 11/12/97 -0500, Daniel A. Christenson espoused the following
wisdom:
() Anyone know if mSQL ver 2.0.3 supports group by???? I really need
()to group data and trying to figure out a way of getting around group by
()if it is not supported (db is about 2 gig's)

Can you use ORDER BY and the manipulate the data?

Something else you can do (that I have done) is search on a field, say
STATE, and then do a sub search for the rows that match that STATE,
something like:

select distinct state from table_name
        for each result
                select city from city_table where state = '$state'
                        do your stuff here

If you want code examples, I could send them. What this bascially boils
down to is simulating nested queries.

j----- k-----

Joshua J. Kügler
Computer Consultant--Web Developer
jkugler@inreach.com - jkugler@bigfoot.com - jk@iname.com - joshuajk@usa.net
http://www.cwebpages.com/jkugler
Every knee shall bow, and every tongue confess, in heaven, on earth, and
under the earth, that Jesus Christ is LORD -- Count on it!