RE: MI-L Sql command for summarising three columns

[Chichester Harbour Conservancy]

Thanks to Russell Lawley and Ian Hull who sent help on the sql command.  =
I wanted to have a query table which had both seawall type and condition =
summarised by length in metres.  The metre column had already been =
updated using the ObjectLen(obj,"m") function.
The solution was as follows:
Select columns: seawall type, quality, seawall_length_metres, =
sum(seawall_length_metres), min(seawall_length_metres), =
max(seawall_length_metres)
>From Tables: seawall_summarised_quality
Group by columns: seawall_type, quality


~~~~~~~~~~~~ List Sponsor ~~~~~~~~~~~~
Digital GEO data for 125 countries
LAND INFO International produces digital geographic data for over 125
countries.   DEMs, satellite imagery, topo maps, vector map layers,
flood maps, and more.   Visit http://www.landinfo.com/indexdm1.htm and let
our specialists find the right solution.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

_______________________________________________________________________
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, send e-mail to [EMAIL PROTECTED] and
put "unsubscribe MapInfo-L" in the message body.