Hi David,
Sum() is an aggregate function that sums exactly one column.
Try using: ( sum(a)+sum(b)+sum(c) ) / sum(d)
Best regards/Med venlig hilsen
Lars V. Nielsen
GisPro, Denmark
http://www.gispro.dk/
- Original Message -
From: Dewen Hou [EMAIL PROTECTED]
To: Mapinfo-L
Hi Group,
Thanks to all those who replied about the Universal Translator. I am going to
wait and try to use MapInfo 7.8 on my other workstation, where the files were
originally created, instead of the 7.0 verion which is what I've been trying to
translate with. Hopefully it works!
My next
: woensdag 17 augustus 2005 23:50
To: Lars V. Nielsen (GisPro); Dewen Hou
Cc: Mapinfo-L
Subject: RE: MI-L SQL question
Hi Group,
Thanks to all those who replied about the Universal Translator. I am going
to wait and try to use MapInfo 7.8 on my other workstation, where the files
were originally created
/ctuzoning/index.htm
-Original Message-
From: Will Mitchell [mailto:[EMAIL PROTECTED]
Sent: Monday, January 10, 2005 1:14 PM
To: [EMAIL PROTECTED]; MapInfo-L@lists.directionsmag.com
Subject: RE: MI-L SQL question
You can reverse the order of the tables in the SQL dialog, should return
You can reverse the order of the tables in the SQL dialog, should return the
first table's geography/polygon...
Will Mitchell
Mitchell Geographics, Inc.
496 Congress St
Portland, ME 04101
ph 207.879.7769
fx 207.253.5756
www.mitchellgeo.com
-Original Message-
From: [EMAIL PROTECTED]
Gerald,
Give this a shot:
SELECT * FROM Table_B WHERE Table_B.PID NOT IN(SELECT Table_A.PID FROM
Table_A)
The principle is called a SQL-Sub Select. The SQL engine will first select
a list of PIDs from Table_A and then compare that list to the PIDs in
Table_B. SQL will only include those
Hi Gerald,
You can't directly select the rows from th table B that are not in table A.
I think the way to do this is :
- create a new column in the table B named common (char 2)
- Update table B :
Table to update Table B
Column to update common
Mark
You can do this: Select street_name From Streets_File Group By street_name .
This will give you all differents street names only one time.
Alejandro
- Original Message -
From: Mark Clute [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, May 16, 2001 1:22 PM
Subject: MI-L
I think the whole expression has to be less than 256, but I can't remember.
The obvious suggestion is to break your SQL statement into sections or
abbreviate.
ex:
SELECT one.NGS_id INTO two
FROM one
WHERE (((one.NGS_id)"1"));
SELECT two.NGS_id INTO three
FROM two
WHERE (((two.NGS_id)"2"));
or
