MI SQL Select
The pull down list of operators in the 'SQL Select' dialog contains five geographic operators. The MapInfo MapBasic manual list seven. The dialog box does not list the 'Contains Part' and 'Partly Within' operators. These two operators have been around since at least MI version 4.0 so why have they never been included in the SQL Select dialohg box? Apart from the MapInfo and MapBasic manuals, is there any documentation available on MapInfo's SQL that could assist the inexperienced user? Thanks, Chris Christopher Prescott Park Systems, Park Services NPWSA Parks Branch Department for Environment and Heritage Email: [EMAIL PROTECTED] Phone: +61 8 8204 9185 Fax:+61 8 8204 9206 The information in this e-mail may be confidential and/or legally privileged. Use or disclosure of the information by anyone other than the intended recipient is prohibited and may be unlawful. If you have received this e-mail in error, please advise by return e-mail or by telephoning +61 8 8204 9237. application/ms-tnef
Re: MI SQL Select full jolin
Hi John, I haven't excactly tried it myself, but this ought to do the the job: 1. This SQL query requires that both of your tables has a Integer column. Lets call it OUTJOIN All the values in these two column should be the same, for instance 1. 2. Your SQL syntax would then be (I guess you allready have seen it): Select * From Table1, Table2 Where Table1.OUTJOIN = Table2.OUTJOIN Into FULLJOIN NoSelect This query ought to give you a table with as many records as the product of the two input tables. It will match each of the records in Table1 with all the records in Table2. Good luck! Peter *** * Peter Moller[EMAIL PROTECTED] GIS-Developer Direct: +45 6313 5008 KampsaxVoice: +45 6313 5013 Rugaardsvej 55 Faximile: +45 6313 5090 DK 5000 Odense CWeb: www.mapinfo.dk MapInfo Authorized Partner *** * -- To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
MI SQL Select full jolin
How do users get around doing a full join on two tables in MI Professional's SQLSelect? Example: I want selection to include a full join on table1.ID1 and table2.ID2, even if ID1 and ID2 do not match? The way SQLSelect works it must be an inner, left, or right join, but no full join. TIA -John -- To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
MI SQL Select Problem
Hello everyone, Just wondering if anyone could help me with a query in MapInfo. The two parts of the OR statement work individually but when combined, I recieve and error. QUERY: (select all points.obj that fall outside of a region.obj) or (select all points.obj that fall within region.obj where points.fieldA does not equal region.fieldA) SQL SELECT: (not obj within any (select obj from region)) or(points.obj Within region.obj and region.CLLIpoints.CLLI) ERROR: No Join Specified Between Tables Can anybody please explain how to make this query work. I'm stumped TIA = ¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤øø¤º°` Andrew McMillan ,,, (905)433-3418(W) GeoSolutions- ActiMedia /'^'\ (905)985-3518(H) Oshawa, ON, Canada ( o o )(905)259-3515(C) oOOO--(_)--OOOo--- email: [EMAIL PROTECTED] ___ Do You Yahoo!? Get your free @yahoo.ca address at http://mail.yahoo.ca -- To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
Re: MI SQL Select Problem
select points.obj from table where points.obj not within region.obj or (points.obj within regions.obj and region.CLLI points.CLLI); Try this. On Wed, 19 Apr 2000, ANDREW MCMILLAN wrote: Hello everyone, Just wondering if anyone could help me with a query in MapInfo. The two parts of the OR statement work individually but when combined, I recieve and error. QUERY: (select all points.obj that fall outside of a region.obj) or (select all points.obj that fall within region.obj where points.fieldA does not equal region.fieldA) SQL SELECT: (not obj within any (select obj from region)) or(points.obj Within region.obj and region.CLLIpoints.CLLI) ERROR: No Join Specified Between Tables Can anybody please explain how to make this query work. I'm stumped TIA = ¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤øø¤º°` Andrew McMillan ,,, (905)433-3418(W) GeoSolutions- ActiMedia /'^'\ (905)985-3518(H) Oshawa, ON, Canada ( o o )(905)259-3515(C) oOOO--(_)--OOOo--- email: [EMAIL PROTECTED] ___ Do You Yahoo!? Get your free @yahoo.ca address at http://mail.yahoo.ca -- To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED] - Erick Posner - "My Mom said she learned how to swim. Someone took her out in the lake and threw her off the boat. That's how she learned how to swim. I said, 'Mom, they weren't trying to teach you how to swim.' " --Paula Poundstone -- To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
Re: MI SQL Select
Martin Sprenz asked: I'm looking for a Query that would select all the polygons that border a selected or given polygon. Is there a function that could achieve this result? The answer you need is select * from My_Table where obj intersects (select obj from selection) The operator for geographic selection [from MapBasic help] are defined as follows objectA Contains objectB first object contains the centroid of second object objectA Contains Part objectB first object contains part of second object objectA Contains Entire objectB first object contains all of second object objectA Within objectB first object's centroid is within the second object objectA Partly Within objectB part of the first object is within the second object objectA Entirely Within objectB the first object is entirely inside the second object objectA Intersects objectB the two objects intersect at some point [my defination is "touch" at some point" Trey Pattillo [EMAIL PROTECTED] http://www.wa3.com -- To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
MI SQL Select
Hello To All, I'm looking for a Query that would select all the polygons that border a selected or given polygon. Is there a function that could achieve this result? Thank you in advance, Marty Sprenz -- To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
RE: MI SQL select syntax
Hi Laith,
There are number of ways to select the rivers and creeks. Here are a few:
Select * From Where Name Like "% RIVER" Or Name Like "% CREEK"
(Using a wildcard %)
Select * From Where Instr(1,Name," RIVER")0 Or Instr(1,Name," CREEK")0
(Looking at the position of "RIVER" or "CREEK" in the column)
Select * From Where Right$(Name,6)=" RIVER" Or Right$(Name,6)=" CREEK"
(Looking at the last 6 characters in the column)
Select * From Where Right$(Name,6)=any(" RIVER"," CREEK")
(Also looking at the last 6 characters in the column)
For a list of all the functions available in a SQL statement, check out the
SQL questions at http://www.spatialplus.com/infobase.htm
Hope this helps.
Regards,
Sue.
adding Susan Port
value Technical Support Coordinator
to [EMAIL PROTECTED]
your
spatial Spatial Plus
systems http://www.spatialplus.com
Friends,
I have data for all types of watercourses. I want to select only those that
are rivers or creeks. One of the columns (NAME) differentiates rivers and
creeks from the rest by its name (eg. Terrania Creek, Brunswick River etc).
What would be the correct syntax to select all rivers and creeks by using this
column?
Also, does anyone know of any good SQL syntax resources, tutorials, teach yourself
by examples???
Thanks in advance,
Laith
=
Laith Wark
EDAW (Aust) P/L
Design, Planning and
Environments Worldwide
Level 4 Rowes Building
235 Edward Street
Brisbane 4000
Australia
Ph: INT +61 (0)7 3229 6422
Fx: INT +61 (0)7 3229 6422
Email: [EMAIL PROTECTED]
=
--
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
--
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
MI SQL select for a text string fragment
Listers, Maybe it's just late in the day but I can't figure out how to select all objects which have the words "Primary route" in a field called "description", eg. "Primary route, Class 1" or "Primary route, whatever". Any suggestions? TIA _ Tim Warman Geologist GIS Specialist Richard C. Slade Associates North Hollywood, CA (818) 506-0418 -- To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
Re: MI SQL select for a text string fragment
Tim, You may use our application "Searchtxt" at : http://std.cpc.ku.ac.th/delta/deltacp/free/free1.htm Give us some feddback Cheers Pancho Tim Warman a écrit : Listers, Maybe it's just late in the day but I can't figure out how to select all objects which have the words "Primary route" in a field called "description", eg. "Primary route, Class 1" or "Primary route, whatever". Any suggestions? TIA _ Tim Warman Geologist GIS Specialist Richard C. Slade Associates North Hollywood, CA (818) 506-0418 -- To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED] -- - Francois Molle - DORAS Centre Kasetsart University, Administrative building 10th floor Bangkhen, 10900 Bangkok, Thailand Tel (University): (66 2) 942.81.75 / Fax(University): (66 2) 942.81.70 Tel/Fax (Home) : (66 2) 287.41.53 / Email : [EMAIL PROTECTED] Website : http://www.ku.ac.th/delta - ORSTOM changes its name to IRD Institut de Recherche pour le Developpement - -- To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
