Original Message-
From: Ronning, Christine [mailto:[EMAIL PROTECTED]
Sent: 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 u
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 qu
quot;Mapinfo-L"
Sent: Wednesday, August 17, 2005 9:38 PM
Subject: MI-L SQL question
Hi All,
I couldn't do a SQL like "sum(a+b+c)/sum(d)" in Mapbasic. Any idea?
Thanks a lot,
David Hou
-
Lis
Hi All,
I couldn't do a SQL like "sum(a+b+c)/sum(d)" in Mapbasic. Any idea?
Thanks a lot,
David Hou
http://www.geocities.com/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
ECTED]
[mailto:[EMAIL PROTECTED]
Sent: Monday, January 10, 2005 10:30 AM
To: MapInfo-L@lists.directionsmag.com
Subject: MI-L SQL question
Group,
It slips my mind right know so, I have an SQL question. I have a point
file and a county file for the US. I want to query all points that fall
withi
Group,
It slips my mind right know so, I have an SQL question. I have a point
file and a county file for the US. I want to query all points that fall
within the county and then give me the County Boundry file. I keep doing
it getting the output of the point file. Any help?
--
Hi all,
trying to join 2 tables with a unique ref in each - easy.
However, in 1 table its a char field and in the other its an integer. For
various reasons I can't change either column type. Now when I try and turn
the int into a char by using Str$() or vice versa by using Val() I get the
old "
Dear list,
I've tried to make a join between 3 base tables in a mb app.
TabA is the main table and TabB & TabC contain a describing tekst to codes i
TabA.
This doesn't work, why:
SELECT TabA.ID, TabB.text, TabC.text
FROM TabA, TabB, TbC
WHERE TabA.code1=TabB.code and TabA.code2=TabC.code
INTO ab
ailto:[EMAIL PROTECTED]]De la part de Kornelsen,
Gerald
Envoyé : 4 juin, 2001 12:35
À : MapInfo-list (E-mail)
Objet : MI-L SQL question
I'm trying to create a superset of all records from previous years' work.
Is there a way to do this:
"Select all the records from table B that are not in
records NOT IN Table_A in the result
set.
Hope this helps!
Ian Erickson
AnalyGIS
http://www.analygis.com/
- Original Message -
From: "Kornelsen, Gerald" <[EMAIL PROTECTED]>
To: "MapInfo-list (E-mail)" <[EMAIL PROTECTED]>
Sent: Monday, June 04, 2001 9:
I'm trying to create a superset of all records from previous years' work.
Is there a way to do this:
"Select all the records from table B that are not in table A" in order to
append these to the superset.
So far, all I've been able to get to work is:
1. select all the records the two tables ha
Subject: MI-L SQL Question
> I have a street file that I want to extract a list of the street names but
I only want the first occurrence of any given street. Can I do a simple SQL
to pick the first observance of a street name and disregard any
reoccu
I have a street file that I want to extract a list of the street names but I only want
the first occurrence of any given street. Can I do a simple SQL to pick the first
observance of a street name and disregard any reoccurrences, if any?
__
can help automate the dissection
of a where clause.
Charles K. Huyck
ImageCat, Inc
http://ImageCatInc.com
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, November 08, 2000 3:21 PM
Subject: MI-L SQL Question
> Greetings,
>
>
Greetings,
Does anyone know of the limitation of the SQL Select Columns and Where
Condition boxes?
I seem to be only allowed a limited number of entries. I thought at first
it was a 256 character issue, but I not even allowed that many.
Any thoughts or suggestions.
TIA
Peter
16 matches
Mail list logo
