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.
