Re: [MI-L] SQL QUERY

-3006 Bern Tel +41 (0)31 368 0180 - Fax +41 (0)31 368 1860 -Original Message- From: Peter Hatton [EMAIL PROTECTED] To: mapinfo-l@lists.directionsmag.com Date: Fri, 10 Mar 2006 17:02:55 +1000 Subject: [MI-L] SQL

MI-L sql query on query tables

hi list, does anybody know if are there any way to perform sql query on query tables thanks to all Sergi Gamis - List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED]

RE: MI-L sql query on query tables

Sergi Select blah from blah where blah into selection (or into csrMyQuery) Select blah from selection (or from csrMyQuery) where ... Terry -Original Message- From: Gamiz Ribelles, Sergi (Regsa) [mailto:[EMAIL PROTECTED] Sent: 20 July 2004 14:55 To: Mapinfo-list (E-mail) Subject: MI-L

MI-L SQL query, where on 2 columns

Hi, I want to do an update, matching values based on two columns. i.e., update column C in table 1 where both columns A and B match in table 2. Cheers, Warwick ___ Warwick Bishop Water Technology P/L 8 Business Park Drive Notting Hill VIC 3168 Phone +61 3 9558 9366 Fax +61

RE: MI-L SQL query, where on 2 columns SUM

Message- From: Warwick Bishop [mailto:[EMAIL PROTECTED] Sent: Thursday, 19 February 2004 10:56 AM To: [EMAIL PROTECTED] Subject: MI-L SQL query, where on 2 columns Hi, I want to do an update, matching values based on two columns. i.e., update column C in table 1 where both columns A and B

Re: MI-L SQL Query

I have a table that I wanted to do a similiar thing to what Andrew Tracey wanted to do. Please see the attachment to see what I did: Select Columns: Province, Type, Count(Sub_Type) 5 From Tables:National_Health_Facility_List_ Where Condition: Group By Columns: Sub_Type

RE: MI-L SQL Query

, 5260 Odense S. Please note our new telephone, direct and telefax numbers. -Original Message- From: Norman Mabunda [mailto:[EMAIL PROTECTED] Sent: Thursday, January 15, 2004 8:14 AM To: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: MI-L SQL Query I have

RE: MI-L SQL Query

. Please note our new telephone, direct and telefax numbers. -Original Message- From: Norman Mabunda [mailto:[EMAIL PROTECTED] Sent: Thursday, January 15, 2004 8:14 AM To: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: MI-L SQL Query I have a table that I

Re: MI-L SQL Query

To do that, you will have to add a field called ID, update it to contain rowid (i.e. 1, 2, 3,) and then include a where clause in your SQL: where rowid=20 or where rowid=20 and rowid=100 If you want to see only the top 20 records in the output (i.e. after the group by), then the answer is

RE: MI-L SQL Query

PROTECTED] Subject: RE: MI-L SQL Query Thanx Peter Another question: Is't possible 1000 records count to see only a certail number of records. For instance, of the 100 records count, to see the 1st 20 records, or to see only 20 records of the 100 records. If yes, how? Regards

Re: MI-L SQL Query

Very much answered. Thanks a mil. Uffe Kousgaard [EMAIL PROTECTED] 01/15/04 09:59AM To do that, you will have to add a field called ID, update it to contain rowid (i.e. 1, 2, 3,) and then include a where clause in your SQL: where rowid=20 or where rowid=20 and rowid=100 If you want to see

RE: MI-L SQL Query

:45 AM To: Peter Horsbøll Møller; [EMAIL PROTECTED] Subject: RE: MI-L SQL Query Thanx Peter Another question: Is't possible 1000 records count to see only a certail number of records. For instance, of the 100 records count, to see the 1st 20 records, or to see only 20 records

MI-L SQL Query

Dear All I have a MapInfo table which comprises ward reference no and tenure type. I am trying to produce a query that will list the 20 wards and a count of how many of each tenure type there are in each ward. I want one browser with all results on. Is this possible. Thanks in advance Andrew

Re: MI-L SQL Query

Yes, the query would go something like this: Select WARD_NO, TENURE_TYPE, Count(TENTURE_TYPE) How_Many From MY_TABLE GROUP BY WARD_NO, TENURE_TYPE ORDER BY WARD_NO, TENURE_TYPE Into RESULTS_TABLE If you are using the SQL select dialog, the first line above is the 'Select Columns', the second

RE: MI-L SQL Query

To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: MI-L SQL Query Yes, the query would go something like this: Select WARD_NO, TENURE_TYPE, Count(TENTURE_TYPE) How_Many From MY_TABLE GROUP BY WARD_NO, TENURE_TYPE ORDER BY WARD_NO, TENURE_TYPE Into RESULTS_TABLE If you are using

AW: MI-L SQL Query

That's an easy one: select * from my_table where textfield into Selection Christof Von: Andrew Tracey [SMTP:[EMAIL PROTECTED] Gesendet am: Dienstag, 12. August 2003 13:11 An: [EMAIL PROTECTED] Betreff: MI-L SQL Query Dear All I am trying to write a query that will allow me

MI-L SQL Query

Dear All I am trying to write a query that will allow me to select all records from a table that have a text entry in one field. I don't want to select the records which have a certain field blank. Does anyone know ho to select all records that have text in a certain field ? Regards Andrew

MI-L SQL Query

Hello all, I have been having a hard time getting the syntax right for a query I need to run. I have a table of points that lands over different regions/boundaries. I want to find the density or points/sq mi, and I am at a loss unless I go to breaking up the two main tables into smaller

MI-L SQL Query

Dear All I have a table which consists of Line, Point and Text data. I need a SQL query that will enable me to pick out either all Text items or all Line items etc. Is this possible to do and does anybody know how ? Thanks in advance Andrew Tracey Development Services Department South Tyneside

RE: MI-L SQL Query

- rectangle 9 - rounded rect 10 - text so if you wanted all lines then n=3 HTH Greg -Original Message- From: Andrew Tracey [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, June 26, 2002 09:01 To: '[EMAIL PROTECTED]' Subject: MI-L SQL Query Dear All I have a table which consists

RE: MI-L SQL Query

Str$(obj) = text is much simpler -Original Message- From: Driver, Greg 9434 [mailto:[EMAIL PROTECTED]] Sent: Wednesday, 26 June 2002 4:55 PM To: 'Andrew Tracey'; '[EMAIL PROTECTED]' Subject: RE: MI-L SQL Query Andrew, From the Query, SQL Select option type: Select Columns: * from

RE: RE: MI-L SQL query to group data on classifications

-04-2002 03:16 Vedr.: RE: MI-L SQL query to group data on classifications

RE: MI-L SQL query to group data on classifications

MyField = update selection set MyField = 4 At least, this works for me. Good luck! DPC -Original Message- From: K Miller [mailto:[EMAIL PROTECTED]] Sent: Monday, April 08, 2002 4:50 PM To: [EMAIL PROTECTED] Subject: MI-L SQL query to group data on classifications Greetings, I am

MI-L SQL Query Question

Listers: Is there any way to select the first 3 records from each group in a query? ie: select * from street_table where ??? group by address results: address1 col1 col2 col3 1 address1 col1 col2 col3 2 address1 col1 col2 col3 3 address2 col1 col2 col3 1 address2 col1 col2

RE: MI-L SQL Query Question

Gutiw [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 02, 2002 11:02 AM To: MapInfo-L (E-mail) Subject: MI-L SQL Query Question Listers: Is there any way to select the first 3 records from each group in a query? ie: select * from street_table where ??? group by address results: address1

Re: MI-L SQL query using three tables

Hi, Thought to just comment on the don't know how you'd join all three = tables within a single SQL. Joining 3 tables in a single SQL proves to be powerful, time saving and = does not clutter your disk with unecessary temporary files. The way to = do this requires a syntax rule which I will

MI-L SQL query using three tables

Dear List I have two tables, each consisting of several thousand polygons - one of hard intertidal vegetation and the other of soft intertidal vegetation and sediments. I have another table of bird count zones. I would like to know if it is possible to use SQL to find out the precise

MI-L Sql query to return unique records

I am sure this is a quite common request, but I can't seem to find an answer... I was wondering what the query structure would be to return a list of unique values from a particular column of a table, in MI. I believe it somehow uses the word Distinct? Can anyone help? Jeff

MI-L SQL Query Problem

Hi, We're having an interesting problem; We're working with two tables, Table A is a list of outlets Table B is a list of competitors' outlets Both tables have Lat/Lon in there. We already have the distance formulas. What we want to do is: For each outlet in Table A, select 7 nearest

MI-L SQL Query Query

Hi All I have a table where I have updated a column to show the object type using Str$ (ObjectInfo(Obj,2)). The result is either Pen (1, 2, 0) or Pen (1, 2, 65280) (black or green lines). Just for fun I then ran a query "Select * from NSG_WDC where Str$(objectinfo(obj,2))="Pen(1,2,65280)" into

RE: MI-L SQL Query Query

PROTECTED]]On Behalf Of Matt Davey Sent: January 15, 2001 11:09 AM To: MI-L (E-mail) Subject: MI-L SQL Query Query Hi All I have a table where I have updated a column to show the object type using Str$ (ObjectInfo(Obj,2)). The result is either Pen (1, 2, 0) or Pen (1, 2, 65280) (black or green li

RE: MI-L SQL Query Query

Matt, I think its a question of syntax. I just tried a similar statement with no trouble: ie Str$(objectinfo(obj,2))="Pen(1,2,65280)" should be written: Str$(objectinfo(obj,2)) like "Pen (1, 2, 65280)" note the use of "like" and the spaces between the word Pen and the "(" and also after the