There is no problem. When you use aggregate function, the result is a table only. If
you use the top fields, you create a subset table.
1) Now you can save your count table and since it has the ID link field it can be
relink again.
2) Another way is to create new fields on you base table and update then from the
aggregate "Count( )" result. You can update the Region_table, field SUMM by getting
the value from (give a name) "Query#" by "Join" where Region_Table.STATE=Query#.STATE.
Hope this helps.
Dyan C. Catamaran
GIS/RS Coordinator
---------------------------------
Phero Tech Inc.
www.pherotech.com
[EMAIL PROTECTED]
P:604-940-9944
F:604-940-9433
>>> "geografica" <[EMAIL PROTECTED]> Friday, February 23, 2001 >>>
Hi listers, I have two tables one with regions (STATES) an other with =
points .....
I want that SQL help me to obtain a new mappable table with : how many =
points are in each region, plus SUM a sales column of the point =
table......and others statistics......... =20
I am using these=20
SELECT COLUMNS : Region_Table.STATE, Count(*), Sum(Point_Table.Sales)
FROM TABLES : Region_Table, Point_Table
WHERE CONDITION : Region_Table.obj Contains Point_Table.obj
GROUP BY COLUMN : Region_Table.STATE
ORDER BY COLUMN : none
into TABLE NAMED : none
WITH THESE I OBTAIN A PERFECT RESULT BUT NOT MAPPEABLE ..... CAN SOME =
BODY TELL ME WHAT IS THE PROBLEM
THANKS IN ADVANCE
matias valenzuela
geografica ltda.
www.geografica.cl
f : 56-32-991632
_______________________________________________________________________
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.
_______________________________________________________________________
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.
