Hi Dyan C. Catamaran,
Select all the records group by from Field B.(Select FieldB from tablename
groupby fieldB) Save this in a temp table. Open both the tables. Select
maintable FieldA = temptable fieldB. I think this will solve your problem.
K.Raghu Rami Reddy <mailto:[EMAIL PROTECTED]>
Patni Computer Systems Ltd,
Electronic Sadan III,
MIDC, Bhosari, Pune - 411015.
India.
Ph: +91-20-7121881
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Dyan
Catamaran
Sent: Friday, April 20, 2001 5:39 AM
To: [EMAIL PROTECTED]
Subject: MI-L Return field content.
Dear Users
Is there a way, maybe with Select or SQL, to select the Table Field's
content without actually knowing its string value? For instance, after
select one polygon, I would like to know what's its Field_# content using a
query request, not the "Identify" tool.
Scenario:
MyTable with 5 records. MyTable has two particular fields I want to query
one against the other. Saying I have in the FIELD_A two records that are
identical to the FIELD_B's content.
_______________
| Field_A | Field_B|
|------------|------------|
| 25 | 25 |
| 1 | |
| 345 | |
| 25 | |
| 100 | |
|-------------------------|
I would like to:
"Select from MyTable all records where Field_A content is equal to Field_B
content"
I expect to select the first and the fourth records. So far I only get one
record selected.
I would appropriate any help.
Sincerely
Dyan C. Catamaran
GIS/RS Coordinator
---------------------------------
Phero Tech Inc.
www.pherotech.com
[EMAIL PROTECTED]
P:604-940-9944
F:604-940-9433
~~~~~~~~~~~~ List Sponsor ~~~~~~~~~~~~
Digital GEO data for 125 countries
LAND INFO International produces digital geographic data for over 125
countries. DEMs, satellite imagery, topo maps, vector map layers,
flood maps, and more. Visit http://www.landinfo.com/indexdm1.htm and let
our specialists find the right solution.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
_______________________________________________________________________
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.
~~~~~~~~~~~~ List Sponsor ~~~~~~~~~~~~
Digital GEO data for 125 countries
LAND INFO International produces digital geographic data for over 125
countries. DEMs, satellite imagery, topo maps, vector map layers,
flood maps, and more. Visit http://www.landinfo.com/indexdm1.htm and let
our specialists find the right solution.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
_______________________________________________________________________
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.
