First you should add a field with a unique value, if you don't already have one.
Then create a copy of your ownership data and run this query: select table1.owner, table1.id, table2.id from table1, table2 where table1.obj intersects table2.obj and table1.id<table2.id and table1.owner=table2.owner into newtable noselect This table will now contain a list of all pairwise neighbouring parcels with the same owner. From here you will have to create some further queries depending on how you exactly want the output. Kind regards Uffe Kousgaard www.routeware.dk ----- Original Message ----- From: "Adrian Allen" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, October 14, 2002 8:43 AM Subject: MI-L selecting adjacent records with the same value > I have some ownership data and we would like to select all parcels were say > an owner owns two parcels and they adjoin each other. > --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 3559
