Good Afternoon All,
I am having some trouble preforming a many to one join in MapInfo 7.0.
I have an excel table that contains citizens drainage complaints and a
parcel table that contains the geography.
I am able to link them together in SQL as follows...
Select * from InCity, MappedDrainageProblems where InCity.Realid =
MappedDrainageProblems.Realid into Selection
However, if there has been more than one problem on a parcel say Problem A
and Problem B on Parcel 123 in my browser I get
Problem Parcel
A 123
A 123
instead of
Problem Parcel
A 123
B 123
What am I doing wrong, does MapInfo have a problem handling many-to-one
joins or is it me?
Any help would be great appreciated.
Leith C. Britt
Town of Cary
Technology Services
Database Analyst
phone: 919-469-4383
fax: 919-319-4597
web: townofcary.org
---------------------------------------------------------------------
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Message number: 11877
