Hi,
So you want to match one single record of the parcels to an owner? Even if the owner has two or more parcels you just want one connected directly? This is possible, but then you need a criteria to join upon, for instance parcel=primary parcel with the restriction that an owner can have only a single primary parcel or max(area) to connect the biggest parcel. Please let MI-L know if you have such a join criteria in mind. You could also build a loop construction with Mapbasic programming to join the lot plan numbers for instance as "Cindy Grey" "1/1234;2/43566" Kind regards, Milo van der Linden AVD-ICT GIS Consultant * Hoogbloklandseweg 24 * 4205 NE Gorinchem Tel. +31 183 50 81 50 Fax. +31 183 50 81 60 Mob. +31 629 54 06 96 -----Original Message----- From: Carolyn Bergin [mailto:[EMAIL PROTECTED] Sent: vrijdag 5 augustus 2005 3:36 To: [email protected] Subject: MI-L Table joins - with duplicates Hi listers, I have two tables. One contains a single list of all property owners (table A) , each is unique, the other contains a list of all properties of which some owners own more than one and although the parcel details are unique the column containing the owners name contains duplicates ( Table B). What im trying to do is to update table A with the property details from table B where my owners name is the same, and so effectively taking information from each record where an owners name matches and updating a single field with these details. Is this possible? Eg Table A Owner Lot Plan Jerry Smith Cindy Grey Table B Lot Plan Owner 1/1234 Cindy Grey 2/43566 Cindy Grey 2/789453 Jerry Smith 4/3782 Jerry Smith The joined table would look like this Owner Jerry Smith 2/789453, 4/3782 Cindy Grey 1/1234, 2/43566 Thanks Carolyn Carolyn Bergin Warren King and Company & Midland Survey Services 2 Victoria Street Midland, WA, Australia 6056 Telephone: +61(08) 9274 2535 Fax: +61(08) 9274 2545 Email: [EMAIL PROTECTED] The information contained in this e-mail message and any attachments may be privileged and confidential. The contents are intended only for the recipient named in this message and any unauthorised use or disclosure is expressly prohibited. As no responsibility is taken for any loss or damage that may be caused by viruses you should scan any attachments for viruses before opening. If you have received this message in error, please notify us and then delete the document. Thank you. --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 17390
