Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have a table of 3,000+ lease files that I'm trying to join to our parcel layer. Each parcel has 4+ leases associated with it, and I need each to be represented by an actual polygon. When I do a traditional join it joins 1 to 1, so it shows 1 of the 4 leases and the others do not join at all. Is it possible to join 1 parcel to many leases and have each show up as an individual polygon? I'm using Arc 10.1.

Thanks in advance, Matt

share|improve this question
If you have not seen it the page Deciding between relationship classes, relates, and joins may be worth looking at. – PolyGeo Nov 14 '12 at 22:43
up vote 1 down vote accepted

use the make query tool in data management.
arcgis resource center says it like this.
I just saw this 1:M tip on arcgis support website.
There does seem to be some other usable information here.
Quick tip to perform 1:Many join

share|improve this answer
Thank you Brad! I'd tried doing a spatial join, but it wouldn't work since only one of the tables was part of a feature class, but the Make Query Tool worked perfectly and just saved me days. Thanks again! – Majape Nov 15 '12 at 18:29

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.